Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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)