Additional if condition

[surajap123]

Hi All,

Currently, I have the below expression used in deciding the background colour of the dimension in the straight table.

=pick(match(Field2,'NY','LD,','JP'),yellow(),Blue(),green())

I want to add additional below condition to the above.

if(field3 = 'Closed',black())

Please see the attached qvw

Please help.

[marcus_sommer · Accepted solution]

Maybe something like this:

if(field3 = 'Closed',black(),
   pick(match(Field2,'NY','LD,','JP'),yellow(),Blue(),green()))

- Marcus

[surajap123]

Thank you so much!