Set Analysis in Dynamic Expression?

vdacanay — Thu, 22 Aug 2013 23:56:01 GMT

This statement works:

sum({$<[STATE]=>} MEMBER_COUNT)

It sums the member count ignore the selection in the STATE field.

This statement does not work:

$(='sum({$<[STATE]=>} MEMBER_COUNT)')

That above statement will ignore the set analysis and sum the member count of only the state selected. Am I doing something wrong here?

I'm asking because ultimately I'm trying to get this expression to work

$(='sum({$<['&(vIndexOnField)>&'=>} MEMBER_COUNT)')

...where vIndexOnField a variable that is set to 1 of 50 possible fields that I may want to index my results against the full set

So, how do I get: $(='sum({$<[STATE]=>} MEMBER_COUNT)') to correctly evaluate ignoring the selections made in the STATE field? Shouldn't that evaluate the same as the first statement?

Thanks,

Vince

Re: Set Analysis in Dynamic Expression?

Anonymous — Fri, 23 Aug 2013 00:05:53 GMT

Vince,

This will work, I tried (assuming I got you question correctly):

sum({$<[$(vIndexOnField)]=>} MEMBER_COUNT)

Regards,

Michael

topic Set Analysis in Dynamic Expression? in QlikView

Set Analysis in Dynamic Expression?

Re: Set Analysis in Dynamic Expression?