Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thank you very much, that worked perfectly.