Skip to main content
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
Master
Master

can you try like below...

 

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