Trigger on worksheet and back ground color

[francisvandergr]

I have an trigger on my worksheet what select automatically year 2015 and 2016.

("2016"|"2015")

In my current selections it is shown like above.

If i select 2016 and 2015 on normal way it is shown like 2016, 2015

I like to use a background colour when 2016 is selected and week > week(today)) the colour must be white (255,255,255)

Formula background:

=  if(GetFieldSelections(Jaar)= '2016, 2015' or  '("2016"|"2015")' AND AsOfWeek > week(today()),ARGB(0,255,255,255),rgb(141,171,203))

Formula of background above does not work. Why not ?

[Oleg_Troyansky · Accepted solution]

I think the problem is in the "OR" part of your condition - you need to repeat the whole condition one more time, not just the values. Also, you should enclose the two conditions connected with "OR", into a set of parentheses, to ensure that OR is performed first, and then AND is applied after that.

=  if(

(GetFieldSelections(Jaar)= '2016, 2015' or GetFieldSelections(Jaar)= '("2016"|"2015")')

AND AsOfWeek > week(today()),ARGB(0,255,255,255),rgb(141,171,203))

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business - The Expert Guide for QlikView and Qlik Sense