topic Set Analysis Problem in QlikView

Set Analysis Problem

Anonymous — Fri, 01 Nov 2013 18:31:19 GMT

I'm trying to figure out how I can get one chart to reflect current selections (no problem) while another chart displays only possible selection minus the current selection.

This image should show what I'm after (the image doesn't show the expression columns where the Set Analysis would be inserted).

Re: Set Analysis Problem

jolivares — Fri, 01 Nov 2013 19:01:00 GMT

In your expresion for the second chart, that is not affected by the selection, include a expression like:

Sum({<LotCode=>} Amount)

Re: Set Analysis Problem

Anonymous — Fri, 01 Nov 2013 19:40:37 GMT

I tried that but the selected Lot Code (in Green) is still in the 2nd chart. I only want the ones in white (associated values).

Re: Set Analysis Problem

jolivares — Fri, 01 Nov 2013 20:05:15 GMT

Ok... this is the possible values, you have to use

Sum({<LotCode = P(LotCode)>} Amount)

Re: Set Analysis Problem

Anonymous — Fri, 01 Nov 2013 20:11:58 GMT

Not quite, but you pointed me in the right direction. This worked:

sum({<[Lot Code]=E([Lot Code])>} Amount)

Re: Set Analysis Problem

rustyfishbones — Fri, 01 Nov 2013 21:02:50 GMT

Hi Brian,

Can you mark your own answer as correct, just makes it easier for the rest of us to find what we need

Thanks

neet solution BTW