Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
Count({$<[Application Status] *= {'Pending'}>} DISTINCT [Application ID])
UPDATE: Note the small * before the equal sign
Try this:
Count({$<[Application Status] *= {'Pending'}>} DISTINCT [Application ID])
UPDATE: Note the small * before the equal sign
Thanks! this was helpful.
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
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?
For set analysis, check the attached document out.