topic Why won't my KPI's update when filtered? in App Development

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

Wed, 23 Mar 2016 20:24:07 GMT

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

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

sunny_talwar — Wed, 23 Mar 2016 20:38:20 GMT

Try this:

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

UPDATE: Note the small * before the equal sign

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

Thu, 24 Mar 2016 17:53:12 GMT

Thanks! this was helpful.

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

sunny_talwar — Thu, 24 Mar 2016 17:59:51 GMT

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

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

Thu, 24 Mar 2016 18:09:20 GMT

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?

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

sunny_talwar — Thu, 24 Mar 2016 18:53:10 GMT

For set analysis, check the attached document out.