topic Re: Strange result combining selection and set expression in QlikView

Strange result combining selection and set expression

mark_casselman — Thu, 28 Nov 2013 22:54:57 GMT

Today I encountered a strage result. Can someone explain and/or resolve this ?

When i make a selection on field AgeGroup I get a normal result in the count of male and female amounts:

But when i make an additional selection on gender i get a strange result:

It is strange to me that when i have selected 'Female' I do get an amount for Male (14). I expected the result to be zero. No Males selected, so the sum of the amount or male should be 0.

The only reason I could come up with is that the set expression <Gender={'Male'}> overrides the selection Gender=Female, though I do specify that the set expression should work on the selection ?

Mark

Re: Strange result combining selection and set expression

jaimeaguilar — Thu, 28 Nov 2013 23:02:05 GMT

Hi,

that's the normal behaviour of Set Analysis, In your case, the expressions will respond to any dimension but Gender. It means that any selection that you make will affect except for Gender. That's because Gender is fixed (Male in one expression and Female in the other. So, in your example if you select Gender = Female it would not affect the expression with Gender = Male,

regards

Re: Strange result combining selection and set expression

mark_casselman — Thu, 28 Nov 2013 23:13:29 GMT

Thanks Jaime,

Any suggestions to get the result 'correct' meaning getting the amount 0 for gender Male when female is selected ? I want to use the formula in a text box and for the user the result is 'wrong', getting male=14 when female is selected.

Re: Strange result combining selection and set expression

swuehl — Thu, 28 Nov 2013 23:30:09 GMT

Try the intersection operator *

=sum({<Gender *= {'Male} >}Amount)