topic Re: Double condition in set analysis in QlikView

Double condition in set analysis

Anonymous — Wed, 14 Jan 2015 20:13:50 GMT

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

Anonymous — Wed, 14 Jan 2015 20:27:40 GMT

I think this should work:

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

Anonymous — Wed, 14 Jan 2015 20:39:05 GMT

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?

Anonymous — Wed, 14 Jan 2015 20:47:19 GMT

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}>}

Anonymous — Wed, 14 Jan 2015 20:52:17 GMT

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

Anonymous — Wed, 14 Jan 2015 20:54:41 GMT

Great to know, thanks!

Anonymous — Wed, 14 Jan 2015 20:55:50 GMT

Thank youuuuuuuu!