Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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 (3)
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