topic Re: How can it works as a filter in QlikView

How can it works as a filter

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

Please see my attached sample model.

In the report , The status condition works base on calculation of the fields Stock on hand, Actual receipts, and Forecast units.

How to make the status filter work when selected ; "Stock out" or "No Stock Out".

Re: How can it works as a filter

sunny_talwar — Wed, 22 Feb 2017 09:30:45 GMT

May be with a calculated dimension

=Aggr(If(GetSelectedCount(Status) = 0, [Product/Code],

If(GetFieldSelections(Status) = 'Stock Out', if(sum(SOH)+sum(purchase_receipts)< (50/100 * sum([Forecast Units])), [Product/Code]),

If(GetFieldSelections(Status) = 'No Stock Out', if(sum(SOH)+sum(purchase_receipts) >= (50/100 * sum([Forecast Units])), [Product/Code])))), [Product/Code])