topic Multiple condition color expression in QlikView

Multiple condition color expression

james_westbrook — Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to place two conditions on a color. I'm using the below expression for red, amber, green but I want to write something along the lines of IF (SUM([Current]-[Original]) < 1 and [DISCUSSION FLAG] = 'X', GREEN().

How do I write 2 conditions for a color based off of 2 data points?

IF (SUM([Current]-[Original]) < 1, GREEN(),

IF ([AT RISK] = 'X', YELLOW()

,RED()))

Re: Multiple condition color expression

sunny_talwar — Tue, 27 Mar 2018 19:52:16 GMT

Have you tried this already?

If(Sum([Current] - [Original]) < 1 and [DISCUSSION FLAG] = 'X', Green(), If([AT RISK] = 'X', Yellow(), Red()))

Re: Multiple condition color expression

james_westbrook — Tue, 27 Mar 2018 20:33:25 GMT

Thanks Sunny. I tried it again and it worked. I must have fat fingered it the first time.

If(Sum([Current] - [Original]) < 1 and [DISCUSSION FLAG] = 'X', RGB(150,255,150),

If(Sum([Current] - [Original]) < 1 and [DISCUSSION FLAG] <>'X', Green(),

If(Sum([Current] - [Original]) > 1 and [DISCUSSION FLAG] = 'X', RGB(255,150,150),

If([AT RISK] = 'X', Yellow()

, Red()))))

Re: Multiple condition color expression

JohnDataAnalyst — Fri, 09 Apr 2021 13:42:23 GMT

Hi Sunny,

I have a similar problems with which I hope you can help.

First problem: I have the field [Pest Qty] which I want to assign three colors to. Any value below 2 should be green, any value between 2 and 5 should be yellow and anything above 5 should be red.

Second problem: I have to assign the above colors to the dimension [PDDD] and within that dimension I would only like to apply that to 'BI' as a subsection of [PDDD].

Third problem: I have multiple subsections of [PDDD], e.g 'BI' 'MEALYBUG' 'FRUIT FLY' with different ranges for each.

Thanks,

Re: Multiple condition color expression

JohnDataAnalyst — Fri, 09 Apr 2021 13:44:08 GMT

I tried the following:

If(Sum([Pest Qty?])<=2 and PDDD='BI',Green()
If(Sum([Pest Qty?])>2 and PDDD='BI', Yellow()
If(Sum([Pest Qty?])>5 and PDDD='BI', Red())))

but to no avail.