Qlik Community

Qlik Sense App Development

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

Not applicable

Why won't my KPI's update when filtered?

Hi,

I'm trying to create a KPI for Pending Apps, Completed Apps, and Denied Apps.  The Dimension is Application Status.

Below is the syntax I'm using to COUNT all Pending Apps.

Count({$<[Application Status]={'Pending'}>} DISTINCT [Application ID])

Everything works correctly to get the COUNT; however, when I use the Application Status filter on my dashboard to filter out Pending Apps, the Count does not change to 0.  The other charts on the dashboard update, but these individual KPI's do not.

Why is this happening?

Thank you in advance for the help!

Kenny

1 Solution

Accepted Solutions
MVP
MVP

Re: Why won't my KPI's update when filtered?

Try this:

Count({$<[Application Status] *= {'Pending'}>} DISTINCT [Application ID])

UPDATE: Note the small * before the equal sign

5 Replies
MVP
MVP

Re: Why won't my KPI's update when filtered?

Try this:

Count({$<[Application Status] *= {'Pending'}>} DISTINCT [Application ID])

UPDATE: Note the small * before the equal sign

Not applicable

Re: Why won't my KPI's update when filtered?

Thanks! this was helpful.

MVP
MVP

Re: Why won't my KPI's update when filtered?

Great, if you got what you were looking for, please close the thread down by marking the correct answer

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks,

Sunny

Not applicable

Re: Why won't my KPI's update when filtered?

Will do.  One last question.. I'm new to Qlik, but I'm having trouble finding a resource that explains the syntax.  Are there are resources or documents available (outside of videos) that do that? 

Also, I get how the "*" works, but can you provide additional background on what it's function is in the Qlik Sense syntax?

MVP
MVP

Re: Why won't my KPI's update when filtered?

For set analysis, check the attached document out.