Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear QV Experts,
Please find enclosed the TestSample.qvw.
'Var' column to be displayed either in Red or Green, if it is greater than 10000 then Green & less than 10000, should be Red.
I selected Traffic Light Gauge with Two Segments. Are there any alternate ways?
Please suggest me.
Hi,
What you have done is right.
You can also use the If statement to do this, but with huge data that may give performance issue.
Regards,
Kaushik Solanki
Hi Sasi,
Another option is to use characters and text colours to reflect this. I have attached a qvw with an extra column attached to reflect this.
The expression used is:
=if(Sum(Sales)-Sum(Spend)>10000,chr(9650), chr(9660))
if greater than 10000 uses chr(9650) which is an up arrow and if it is less than 10000 uses chr(9660) which is a down arrow.
Then clicked on the plus sign next to the expression name. Select the text color options and use the same if statement, however this time with RGB values for true and false:
=if(Sum(Sales)-Sum(Spend)>10000,green(), red())
Of course, if you want to use different symbols, read this:
How to find a number for a char: chr() and ord() functions
which is very helpful.
Hope this helps.
Paul
You can use Ascii characters 9650 & 9660
if( Variance > 10000, chr(9650), chr(9660))
You will also need to set the text colour of the expression
if( Variance > 10000, rgb(0,128,0), rgb(255,0,0))
Try if condition.
if([Sales] - [Spend] > 10000,rgb(0,127,0),rgb(255,0,0))
-Sathish
-Sathish
Hi,
Check the attachment.
Thanks a lot for all for your valued solutions.