Exclude selection data from chart

[#1]

I have a requirement to have one chart display the data related to a selection or user, but then have another chart displayed that contains data for "everyone else". So I'm having some trouble figuring out how to, not just make the second chart ignore the selection, but actually filter out the data in the second chart based on that selection.

-Selection box with user names

-1st Chart that displays data for the selected User(s)

-2nd Chart to display the data for all the other users

Is this possible in QlikView?

Thanks!

[maxgro]

maybe with set analysis and the E(), excluded values of a field

[#3]

I have a similar requirement to exclude values selected in particular field...Can someone help

Field

A

B

C

If A is selected I want to remove all the data related to A in my expression Sum(Amount)

[gautik92]

you can use E() Excluded function with set analysis