Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
miguelcunha
Contributor

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

1 Solution

Accepted Solutions

Re: How to use OR on sum condition

But why not just this

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

View solution in original post

3 Replies

Re: How to use OR on sum condition

May be like this

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

Re: How to use OR on sum condition

But why not just this

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

View solution in original post

miguelcunha
Contributor

Re: How to use OR on sum condition

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