Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

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

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

View solution in original post

5 Replies
jolivares
Specialist
Specialist

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

Sum({<LotCode=>} Amount)

Anonymous
Not applicable
Author

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

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

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

Anonymous
Not applicable
Author

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

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

rustyfishbones
Master II
Master II

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