How to build a EXCLUDE FROM filter in QlikSense?

[rvijayanth]

Here is my data:

Design ID	Color
100	Yellow
100	Green
200	Yellow
200	Blue

I have a filter pane for "Color":

If I select Yellow, we show Design ID 100 and 200

***Below is my requirement***

I want to have a second filter called "Exclude Color":

If I select Yellow in filter filter and "Green" in second (exclude) filter, I want to be able to exclude the row where Color is Green and return just Design ID 200. 

Please help me to figure this out. 

[rvijayanth]

Design ID	Color
100	Yellow
100	Green
200	Yellow
200	Blue

I have a filter pane for "Color":

If I select Yellow, we show Design ID 100 and 200

***Below is my requirement***

I want to have a second filter called "Exclude Color":

If I select Yellow in filter filter and "Green" in second (exclude) filter, I want to be able to exclude the row where Color is Green and return just Design ID 200. 

Please help me to figure this out. 

[UserID2626]

Hi,

create an alias name for the field color first

LOAD
Business_Date,
Pack as "Pack Type",
Pack,
Amount
FROM [lib://Ex/Combochart Sample.xlsx]
(ooxml, embedded labels, table is Sheet1);

then keep as two separate filter and set an alternate state for one filter 

then create a measure with alternate state

https://community.qlik.com/t5/QlikView-App-Development/Is-possible-to-use-alternate-States-with-set-...

https://community.qlik.com/t5/New-to-Qlik-Sense/Alternate-state-in-Calculation-condition-section-qli...

if(GetSelectedCount(Pack)>0 and GetSelectedCount([Pack Type],true(),'A')>0,
Sum({<Pack=$::Pack,[Pack Type]-=[A]::[Pack Type]>}[Amount])
,
if(GetSelectedCount(Pack)>0,
Sum({<Pack=$::Pack>}[Amount])

,
if(GetSelectedCount([Pack Type],true(),'A')>0,
Sum({<[Pack Type]-=[A]::[Pack Type]>}[Amount]))))

Attaching sample app

[rvijayanth]

Thanks for the reply. I will try this solution