Filter table based on a condition for measure

[NewToQlikSens]

Hi,

I have a field call unit_cost which is a SUM measure. Is there a way to filter this table to show records for whose values are less than/greater than 100.  If less than 100, only row 1 and 5 should be shown and vice versa.

I have tried set analysis, but not really getting the answer I'm looking for, as it is just subtracting from the existing values i think.

I have tried like this -> SUM({$<[unit_cost_]={"<=100"}>}[unit_cost])

Any help would be appreciated.

Thanks

[MatheusC · Accepted solution]

@NewToQlikSens 
see it like this:

sum({<product_type_en= {"=sum(unit_cost)<=100"}>} unit_cost)

 Regarts,
Matheus

[NewToQlikSens]

Thank you for the reply. Yes it is working.

But I'm not getting why we need to use product_type_en in the query, is it not possible only with unit cost?

[MatheusC]

Good, 👍

Because in this case we are filtering within the expression only the product_type_en that follow the calculation condition, that is, those whose sum(unit_cost) is <=100

Regarts, Matheus