KPI does not change to 0 when filter on the value that is not in count expression

[lyngkll]

Hi,

I am counting 2 measures, 

If the "Coding" value is "Late", then count(SalesNumber). This is in 1 KPI

If the "Coding" value is "On-time", then count(SalesNumber). This is in another KPI

But when I filter on a stacked bar chart that shows the share of these 2 values "Late" vs "On-time", to "Late" part only, the KPI above for "On-time" still shows a value. I want this to be 0 instead.

Could someone please guide how should I solve this issue?

Thanks in advance!

[MayilVahanan · Accepted solution]

HI

Try like below

count({<Coding*={'On-time'}>}SalesNumber)

[lyngkll]

Thanks a lot @MayilVahanan for the quick response

It works! Could you please explain what "*" mean in this case or direct me to any material that explains it?

Thank you so much!

[MayilVahanan]

Hi

Its intersection operator [i.e. its will reflect based on selection and given set values]

Set operators | Qlik Sense on Windows Help