Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
gr_eldred
Creator II
Creator II

apply and and or operators in set analysis.

apply and and or operators in set analysis.

I need help to apply an operator or to this set analysis. can you help me?

count({$<Flag_AltoValor={'A'}> + <art_serie_fab={'S'}> and <Cli_General={'S'}>} DISTINCT %Folio_Fac)

regards

2 Replies
rubenmarin

Hi Eldred,  '*' is 'and' (like '+' is 'or'), and you can use parenthesys to group conditions so:

count({$(<Flag_AltoValor={'A'}> + <art_serie_fab={'S'}>)*<Cli_General={'S'}>} DISTINCT %Folio_Fac)

sunny_talwar

You can also do this

Count({$<Flag_AltoValor={'A'}, Cli_General={'S'}> + <art_serie_fab={'S'}, Cli_General={'S'}>} DISTINCT %Folio_Fac)