
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Filter table based on a condition for measure
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@NewToQlikSens
see it like this:
sum({<product_type_en= {"=sum(unit_cost)<=100"}>} unit_cost)
Regarts,
Matheus

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@NewToQlikSens
see it like this:
sum({<product_type_en= {"=sum(unit_cost)<=100"}>} unit_cost)
Regarts,
Matheus

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
