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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)