Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
hucand
Contributor II
Contributor II

Count table rows based on multiple cell values

I have a table in a sheet with multiple measures

 

id measure1 measure2 measure3 measure4
1001 10 0 0 0
1002 9 0 1 0
1003 5 0 0 0

 

How would I get a count of rows that have 0s in measure2 measure 3 and measure4?

Labels (3)
2 Replies
Chanty4u
MVP
MVP

Not sure but you can try this 

Count({<measure2={0}, measure3={0}, measure4={0}>} id)

 

BrunPierre
Partner - Master
Partner - Master

Count(DISTINCT If(measure2=0 and measure3=0 and meaure4=0, id))
Or
Count(DISTINCT{<id={"=measure2=0 and measure3=0 and measure4=0"}>}id)