Using 'Visual Cues' and values from other expressions

[peterderrington]

Hi,

I have a straight table with 3 Columns, I was wanting to use the 'Visual Cues' tab to colour anything in Column 3 Green if it was higher than Column 2 and Red if it was lower.

I can't seem to work out how to achieve this simple task though.

Any ideas?

Thanks,

Peter

[skamath1]

each column has an option to apply the background color. in the measure property, expand the column 3 (assuming it is QlikView), it will show background . in the expression of background enter the If(Column(3) > Column(2), LightGreen())

[QFabian · Accepted solution]

Hi, instead of visual cues, you can use expression properties, like this : 

[peterderrington]

Fab, Thank you.

I've yet to use the 'Visual Cues' stuff for anything, its a bit crackers to have to use the Expression tab all the time but never mind, as long as it works.

[QFabian]

in that case, you can create variables, one for each expression, then , use the visual cues like this :

variable overview :

chart properties