Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rvijayanth
Creator
Creator

How to build a EXCLUDE FROM filter in QlikSense?

Here is my data:

Design IDColor
100Yellow
100Green
200Yellow
200Blue

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. 

 

 

 

 

Labels (1)
1 Reply
rvijayanth
Creator
Creator

Is this possible in qlikaense using P and E operations?