0 Replies Latest reply: Oct 24, 2017 12:39 PM by Jonah Van Quekelberghe RSS

    Filter data based on measure (greater than, ...)

    Jonah Van Quekelberghe



      I have a datamodel with data per month per account. In it I have data linked to account that is on a finer level which I aggregate on account level.


      I would for example do a sum(Measure1) as a masteritem "Measure1"  and then show this measure in a table per month per account.


      I would like to let the end user do selections based on the measure


      • Give accounts that have Measure >1000
      • Give accounts with SUM between 500 and 100


      I actually have multiple measures and would like the user to select on each measure. For example : give account that have for Measure1 more than 1000 and than do another selection on Measure2 saying less than.


      I have been searching a bit on the internet & Qlik Forum and am yet to find a solution.


      I was wondering what other solution there are other than those indicated below (ideally I would be able to add my measure on the filter tab ):


      • Add the aggregate on account level in the script, but this will not resolve my problem nor be dynamic.
      • Creat a dimension with the AGGR function, which become dynamic.

      Thanks in advance!