Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
peterderrington
Creator II
Creator II

Using 'Visual Cues' and values from other expressions

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

 

1 Solution

Accepted Solutions
QFabian
Specialist II
Specialist II

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

QFabian_0-1607349646219.png

 

QFabian

View solution in original post

4 Replies
skamath1
Creator III
Creator III

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
Specialist II
Specialist II

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

QFabian_0-1607349646219.png

 

QFabian

View solution in original post

peterderrington
Creator II
Creator II
Author

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
Specialist II
Specialist II

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

variable overview :

QFabian_1-1607351527560.png

chart properties

QFabian_0-1607351504423.png

 

QFabian