topic Re: Using 'Visual Cues' and values from other expressions in QlikView

Using 'Visual Cues' and values from other expressions

peterderrington — Mon, 07 Dec 2020 13:19:54 GMT

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

Re: Using 'Visual Cues' and values from other expressions

skamath1 — Mon, 07 Dec 2020 13:59:14 GMT

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())

Re: Using 'Visual Cues' and values from other expressions

QFabian — Mon, 07 Dec 2020 14:00:44 GMT

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

Re: Using 'Visual Cues' and values from other expressions

peterderrington — Mon, 07 Dec 2020 14:10:41 GMT

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.

Re: Using 'Visual Cues' and values from other expressions

QFabian — Mon, 07 Dec 2020 14:32:30 GMT

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

variable overview :

chart properties