Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
wesbrowning
Partner - Contributor III
Partner - Contributor III

Help with COUNT of FIELD equal to specific value

Here's what I'm hoping to display in KPI: Count({[Priority] = '3 - Medium'}) 

Field is "Priority" and wanting to count number of times it's equal to "3 - Medium"

I know this is so easy for you folks - hoping someone can clarify this for me.  I'm just starting out (as you can tell)...

10 Replies
Rohan
Partner - Specialist
Partner - Specialist

Hey, have you tried something like this in the script :

If(date-previous(date)>1, 'yes','no') as flag,

& Then call this flag in the count like :

Count ({1<flag={'yes'}>} flag).

Tell me if this works. Good Luck