Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dszakris
Contributor II
Contributor II

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

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

1 Solution

Accepted Solutions
abhijitnalekar
Specialist
Specialist

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.

 

Regards,
Abhijit
keep Qliking...

View solution in original post

2 Replies
abhijitnalekar
Specialist
Specialist

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.

 

Regards,
Abhijit
keep Qliking...
dszakris
Contributor II
Contributor II
Author

Thank you very much, that worked perfectly.