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

[dszakris]

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

[abhijitnalekar · Accepted solution]

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.

[dszakris]

Thank you very much, that worked perfectly.