topic Count 2 Conditions in QlikView

Count 2 Conditions

mnmcclo — Mon, 26 Jan 2026 16:26:21 GMT

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)))

Re: Count 2 Conditions

Or — Thu, 17 Nov 2022 14:01:07 GMT

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])

Re: Count 2 Conditions

mnmcclo — Thu, 17 Nov 2022 14:05:38 GMT

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