topic Re: Additional if condition in QlikView

Additional if condition

surajap123 — Mon, 23 Aug 2021 07:54:47 GMT

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 — Mon, 23 Aug 2021 08:40:15 GMT

Maybe something like this:

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

- Marcus

surajap123 — Mon, 23 Aug 2021 09:49:10 GMT

Thank you so much!