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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
mnmcclo
Contributor
Contributor

Count 2 Conditions

I have been attempting to count 2 features on a table that is filtering through multiple features and each time, it gives me the entire count of features rather than the 2 specific ones.

I need to count 'To Do' and 'Not Started'. What am I doing wrong?

count(if(match([Feature Status], 'In Design', 'Development', 'Read for Test', 'Not Stated', 'To Do'),

if([Feature Status]= 'To Do', 1)

+

if([Feature Status]= 'Not Started', 1)))

Labels (4)
2 Replies
Or
MVP
MVP

I'm not entirely sure what you're trying to achieve here, but if I read this correctly, perhaps:

Count( {< [Feature Status] = {'To Do','Not Started'} >} [Feature Status])

mnmcclo
Contributor
Contributor
Author

This is perfect! Thank you. Definitely over complicated that one