QlikView App Dev

[vovan4ik]

Hi guys.

Is there anybody who knows how to set up conditions in set analysis

Field AAA tags (Member, Not Member)

Field BBB tags (Yes, No, Didn't want it)

I want calculate people who selected from field AAA ={'Not Member'} or (AAA={'Member'} and BBB={'Didn't want it'}

Thank you

[mov · Accepted solution]

I think this should work:

{ <AAA ={'Not Member'} > + <(AAA={'Member'}, BBB={'Didn't want it'}> }

[vovan4ik]

Thanks Michael. You're always the best

If I have another condition for both CCC={9,10}

I should use

{ <AAA ={'Not Member'} ,CCC={9,10}> + <(AAA={'Member'}, BBB={'Didn't want it'},CCC={9,10}> }

or there is other way?

[mov]

Your syntax looks correct to me.  Out of curiosity, you can try this, but I'm not sure if it works

{(<AAA ={'Not Member'} > + <(AAA={'Member'} and BBB={'Didn't want it'}>) * <CCC={9,10}>}

[vovan4ik]

Works!!!!!!!!!!!!!!!!!!!!!!!!!!

[mov]

Great to know, thanks!

[vovan4ik]

Thank youuuuuuuu!