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

Anonymous — Tue, 24 Oct 2017 16:39:13 GMT

Hello,

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!

topic Filter data based on measure (greater than, ...) in App Development

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