Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
Hi ,
You Can Able to add condition in your expression .
see the below image
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.