topic conditional format: show red if lower than 2 variables depending on value of another field in QlikView

conditional format: show red if lower than 2 variables depending on value of another field

chriscools — Tue, 10 May 2016 15:31:26 GMT

Hello,

i want to have conditional formatting for calculated values.

i don't think i can do it with visual cues, because it depends of the value in another field.

there is a field "LegalEntity", and if the value for LegalEntity is "1" then the calculated value should show in red

if it is lower than "variable1".

If the LegalEntity is "2", then the calculated value should be in red whenever it is lower than "variable2".

Is this possible and how should i do it?

is it also with visual cues or is there another way?

grtz

Chris

sunny_talwar — Tue, 10 May 2016 15:34:16 GMT

Use a background color expression like this may be:

If(LegalEntity = 1,

If(Expression < variable1, Red(), AnotherColor),

If(LegalEntity = 2,

If(Expression < variable2, Red(), AnotherColor))

ramoncova06 — Tue, 10 May 2016 16:14:20 GMT

expand the expression and the select background color

then go to definition and enter whatever formula you want to use

chriscools — Tue, 10 May 2016 21:32:59 GMT

thanx, this was perfect!!!

grtz,

chris