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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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
MVP
MVP

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

May be like this

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

sunny_talwar
MVP
MVP

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