My KPI wont go to zero.

[Markbhai]

I have set some KPI's which count the status of support tickets and am showing a pie chart beside the KPIs as a different view.

My status are e.g. 'New', 'Open', 'Closed' - I also have a 'Total' KPI

This is my KPI expression: 

count({<[Request Status]={'Complete'}>}[Request Status])

If I select 'Open' in the pie chart, I would expect all of the other Status KPI to change to Zero.

I have also tried this expression with the same result:

{<[Request Status]={`Complete`}>} count(distinct [id])

Any advice?

[Chanty4u]

try this

count({<[Request Status]={'Complete'}>} [Request Status])

count({<[Request Status]={'Open', 'New'}>} [Request Status])

[Markbhai]

Thats not working for me.

I don't know if it is relevant but I am using 'Measures' Master Items for my KPI and the expression is being added to the Measure

The first expression is the one that I was using, it calculates the correct number of tickets with the status of complete, but the KPI wont change when I select a different KPI in the Pie Chart.  My logic is that if I select for example 'New' only in the pie chart the KPI for 'Total' will change (it does), the KPI for 'New' will change (it does) and the KPI for 'Complete' will change to zero, which is doesnt.

(In case I was missing something, I tried both expressions but got a 'garbage expression' statement.

[Aditya_Chitale · Accepted solution]

@Markbhai ,

Use  *  in your measure expression. Like this : 

count({<[Request Status]*={'Complete'}>} [Request Status])

Change all measure expression in similar way. It performs intersection with your selection &  filters passed in set expression.

Regards,

Aditya

[MayilVahanan]

Hi

It will work with intersection operator (*).

Try like below

count({<[Request Status]*={'Complete'}>} [Request Status])

[Markbhai]

Thanks Guys.

I this works. - I am very new to Qlik (a day or so) and very confused by the syntax and was trying to put it inside of the square brackets. - Thanks for the help.