Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

bgarland
Contributor III

Set Analysis Problem

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).

SetAnalysisProblem.jpg

1 Solution

Accepted Solutions
bgarland
Contributor III

Re: Set Analysis Problem

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

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

5 Replies
jolivares
Valued Contributor

Re: Set Analysis Problem

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

Sum({<LotCode=>} Amount)

bgarland
Contributor III

Re: Set Analysis Problem

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).

jolivares
Valued Contributor

Re: Set Analysis Problem

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

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

bgarland
Contributor III

Re: Set Analysis Problem

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

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

rustyfishbones
Honored Contributor II

Re: Set Analysis Problem

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

Al

Community Browser