Qliksense - filter by measure result

[NormanStanleyBadger]

Cello - is it possible to filter records by measure so that they are not included in table totals? 

For example, after an auction I would like to exclude any items that did not achieve 60% of their reserve?

I thought I can could use limitations but this only appears to remove items from view not from the total calculation of the data set.

[chrismarlow]

Hi,

If your sale and reserve numbers don't need to be aggregated (i.e. although you might use Sum in your chart you are only really adding up one number) then you can use if, so something similar to;

Sum(if(sale>0.6*reserve,sale,null()))

(You may also need to turn off Include Zero values/similar)

If you did need to add up sale & reserve numbers before doing the test then it would be a bit more complicated, but is possible, would depend on your data model.

Cheers,

Chris.