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

Announcements
Join us in Zurich on Sept 24th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to use OR on sum condition

Hey guys

How can i do the following?

count({<Date_year={$(=Max(Data_Ano))},(Marca={'ZZ'} or Marca={'HN'})>} Tipo_publicacao)

Is is possible to use the "OR" operator, or do I have to separate them?

Thanks in advance,

Miguel Cunha

Labels (2)
1 Solution

Accepted Solutions
sunny_talwar

But why not just this

Count({<Date_year={$(=Max(Data_Ano))}, Marca={'ZZ', 'HN'}>} Tipo_publicacao)

View solution in original post

3 Replies
sunny_talwar

May be like this

Count({<Date_year={$(=Max(Data_Ano))},(Marca={'ZZ'}>+<Marca={'HN'})>} Tipo_publicacao)

sunny_talwar

But why not just this

Count({<Date_year={$(=Max(Data_Ano))}, Marca={'ZZ', 'HN'}>} Tipo_publicacao)

Anonymous
Not applicable
Author

That's exactly what I needed! Thank you very much