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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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