topic How is "Ignore" a single in set filters in Calculated Field? in Visualization and Usability

How is "Ignore" a single in set filters in Calculated Field?

dszakris — Tue, 16 Nov 2021 14:03:17 GMT

Hello All,

I'm new to QLikSense.

I am trying to keep a KPI with a calculated field with a figure in it. I need my filters to exclude "Rejected" order, but I need the KPI to show a sum of rejected orders.

I have multiple filters (month, department, etc) and if these change the KPI needs to change, but I need the KPI to ignore order status no matter.

My calculated field is:

=Count(if (match(ORDER_STATUS, 'Rejected'), 'Rejected'))

Order Status has other possible values of: Cancelled, Accepted, Awaiting Dispatch, Sent

Re: How is "Ignore" a single in set filters in Calculated Field?

abhijitnalekar — Tue, 16 Nov 2021 18:06:23 GMT

Hi @dszakris ,

From my understanding i will suggest to modify the expression as below

Count({<ORDER_STATUS=>}
if (match(ORDER_STATUS, 'Rejected'), 'Rejected'))

{<ORDER_STATUS=>} this will ignore the order status filter. it will show always Rejected count though you have selected the Accepted.

Re: How is "Ignore" a single in set filters in Calculated Field?

dszakris — Wed, 17 Nov 2021 08:44:33 GMT

Thank you very much, that worked perfectly.