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: 
Patman
Contributor III
Contributor III

Count if Column A = X or Column A = Y

Please advise,

I have tried this but it appears to only count the second item.

Count({<[Column A]={'Open'},[Column A]={'Eff-Check'}>} [Column A])

 

also looking to solve, Count if Column B does not contain 13 where 13 is part of a string ( Like this 13OKabcedf, or 13NOKasdver) 

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Just list the values separated by commas: Count({<[Column A]={'Open','Eff-Check'}>} [Column A])

And with the second condition for Column B: Count({<[Column A]={'Open','Eff-Check'}, [Column B] -= {"13*"} >} [Column A])

 


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

Just list the values separated by commas: Count({<[Column A]={'Open','Eff-Check'}>} [Column A])

And with the second condition for Column B: Count({<[Column A]={'Open','Eff-Check'}, [Column B] -= {"13*"} >} [Column A])

 


talk is cheap, supply exceeds demand