Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Straight table Visual Cue

Hi Guys,

I wanted to set the visual cue of an expression by comparing it to another field in the same row. It doesnt seem to work. Is this even possible in QV?

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Yes, but not using the visual cues. You can click on the + in front of an expression on the Expressions tab. If you then select Background Color you can enter an expression in the Definition box to calculate a color. For example if(Field1>Field2, lightred(), lightgreen() ) to change the background color to red if the value in Field1 is larger than the value in Field2.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
kumarnatarajan
Partner - Specialist
Partner - Specialist

Hi ,

You Can Able to add condition in your expression .

see the below image

Capture.PNG

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Yes, but not using the visual cues. You can click on the + in front of an expression on the Expressions tab. If you then select Background Color you can enter an expression in the Definition box to calculate a color. For example if(Field1>Field2, lightred(), lightgreen() ) to change the background color to red if the value in Field1 is larger than the value in Field2.


talk is cheap, supply exceeds demand