topic Re: Filter table based on a condition for measure in Integration, Extension & APIs

Filter table based on a condition for measure

NewToQlikSens — Mon, 11 Mar 2024 12:13:32 GMT

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

Re: Filter table based on a condition for measure

MatheusC — Mon, 11 Mar 2024 14:51:26 GMT

@NewToQlikSens
see it like this:

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

Regarts,
Matheus

Re: Filter table based on a condition for measure

NewToQlikSens — Tue, 12 Mar 2024 05:47:13 GMT

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?

Re: Filter table based on a condition for measure

MatheusC — Tue, 12 Mar 2024 12:57:36 GMT

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