Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

How to "filter" a KPI?

Hey guys,

I am creating a KPI's of safety priority (High, Medium, Low). I have a dimension called "Priority" that lists the priority (High, Medium, Low) for each safety case. Unfortunately when creating the KPI, sum(Priority) counts all of them whereas I would like to be able to just list the number of each (Ex: Number of "High" priority cases).

Is there an if statement or something I can use? Thanks for your help.

1 Solution

Accepted Solutions
arthur_dom
Contributor III

Re: How to "filter" a KPI?

you could use , for exempla, for high the expression

Count( {<Priority={'High'}>} )

It is set analysis. For more read Set Analysis: syntaxes, examples

View solution in original post

4 Replies
arthur_dom
Contributor III

Re: How to "filter" a KPI?

you could use , for exempla, for high the expression

Count( {<Priority={'High'}>} )

It is set analysis. For more read Set Analysis: syntaxes, examples

View solution in original post

Not applicable

Re: How to "filter" a KPI?

Hi, thanks for your response.

I tried copying and pasting that expression into the expression line, but for some reason it's not recognizing it. Is there anything else I need to do? For the record, "High" is not a dimension. Only priority is.

arthur_dom
Contributor III

Re: How to "filter" a KPI?

Hi...

Maybe it's wrongly write... Use the idea o set analysis, or if you can send the qvf file so i can take a look.

Not applicable

Re: How to "filter" a KPI?

I think I got it. The expression ended up being:

Count({<Priority={"High"}>}Priority)

Thanks for pointing me in the right direction. The link to set analysis was very helpful.