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
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
coloful_architect
Contributor III
Contributor III

conditional filters for selecting multiple dimensions.

Hi gurus,

 

I  have a group of dataset like this 

dataAttributesFlag
aRedyes
bBlueno
cPurpleyes
dcolorfulno
ecolorfulno
fcolorfulyes
gWhiteno

 

if I filter out Flag yes, it returns me data with Red, Purple and Colorful.

dataAttributesFlag
aRedyes
cPurpleyes
fcolorfulyes

 

is there a way, at filter panel for either Attributes or Flag , to achieve a conditional filter to only have Red and Purple without colorful.

I am thinking an expression like " if Flg = Yes, only attributes =Purple and Red"

any other ways to achieve this is also welcome. 

much appreciated.

 

2 Replies
GaryGiles
Specialist
Specialist

Are you looking for something like:

aggr(Only({$<Flg={'Yes'},Attributes={'Red','Purple'}>} Attributes), Attributes)

or, to exclude 'colorful' instead of including 'Red' and 'Purple, use:

aggr(Only({$<Flg={'Yes'},Attributes-={'colorful'}>} Attributes), Attributes)

 

coloful_architect
Contributor III
Contributor III
Author

ummm I tried this .but the panel filter of attributes turn to be only red , purple. 

By default, I want to have that attributes panel filter to have all the data ( all colors )

I guess if I have to recreate a demission  particularly for yes Flag + Purple +Red ?