title: Filtering by a calculated measure involving multiple fields in Qlik Sense
body: <p>I am trying to use a calculated measure as a way to filter my data, but it's looking more difficult than expected. Let me explain through an example.</p>
  
  <p>I have data of the following type, with two dimensions - one is a unique ID, the other a category - and four measures. </p>
  
  <p><a href="http://i.stack.imgur.com/BEl0V.png" rel="nofollow">Initial table</a></p>
  
  <p>My first step is to rank each element by its score, where the ranking is evaluated within the same category.  I therefore create a new measure: </p>
  
  <pre><code>=aggr(rank(sum(Score1)), Category, UniqueID)
  </code></pre>
  
  <p>I do this for all three scores, resulting in three new calculated measures. My final calculated measure is the average of the three rankings. Below the example, the calculated measure of interest is the one in bold. Note that in my real world calculation I directly evaluate 'New Measure', without creating the intermediate columns 'RankingScore'.</p>
  
  <p><a href="http://i.stack.imgur.com/KoVUm.png" rel="nofollow">Data with newly calculated measure</a> </p>
  
  <p><strong>Note that this measure is tricky, as it changes according to previous selections</strong>. Say, for instance, that I select only entries with 'Amount' > 1000. The relative rankings will change and therefore also 'New Measure'.</p>
  
  <p>In my actual App I need to filter my entries by 'New Measure', after I've done some previous selections on fields like 'Amount'. If it simply were a field, I would normally have created a filter pane, our used the <strong>qsVariable</strong> extension to have a slide range, to select only rows with 'New Measure' above a set threshold. Unfortunately it seems I cannot do that with my calculated measure. </p>
  
  <p>How would you approach the problem? I was wondering, for example, if it were possible to 'convert' my new measure to an actual field, after all previous selections have been done, but perhaps this is nonsense.</p>
  
  <p>Thank you in advance, and apologies for the long post!</p>