topic Set Analysis And + Or in QlikView

Set Analysis And + Or

ilanbaruch — Tue, 09 Feb 2021 18:40:15 GMT

hi all

in my model I have an expression based set Analysis 'OR' :

Count({$<Flag_1={'1'}>+<Flag_2={'1'}> } distinct client_id)

I want to add another flag to the expression 'AND' Flag_3

any ideas ?

advanced thanks

edwin — Tue, 09 Feb 2021 18:45:44 GMT

if you add Flag_3 inside each of the modifiers that will be equivalent to an AND:
<Flag_1={'1'},Flag_3={'1'}>

MayilVahanan — Wed, 10 Feb 2021 01:41:02 GMT

Try like below

Count({$<Flag_1={'1'},Flag_3 ={1}>+<Flag_2={'1'},Flag_3 ={1}> } distinct client_id)