Skip to main content

New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jokar
Contributor II
Contributor II

Ignore selections in colour expression

Hi All,

I am trying to write a colour expression which ignores my date filters but am having a lot of trouble getting it to work. This is the colour expression:

if(Year= '2021', 'Lightgray', if(Year= '2022', 'Green'))

I created a variable called vIgnoreDates which I want to add to this expression so that it ignores selections. 

Can someone please help me on what expression I should use?

Thank you in advance

Labels (4)
1 Reply
anat
Specialist II
Specialist II

can you try like below...

 

if(only({<Date=,date2=>}Year)= '2021', 'Lightgray', if(only({<Date=,date2=>}Year)== '2022', 'Green'))