Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I have one dimension and 1 expression.My expression is in percentage.I want the background color filled according to the value in the cell.I have attached the requirement.
Can please someone help on this?
Regards,
Sahana
We cannot show both Value and gauge in same cell , you will have to add another column to show the values in it
A trick you can try is
Add a column showing values before the linear gauge and fill it with the same color and uncheck vertical expression borders in the Style tab
Could you provide sample application
Hi,
Something like this -
=if([Your Expression Name] >= '85%' , Green(),
if([Your Expression Name] >= '50%' and [Your Expression Name] < '85%' , Yellow(),
If([Your Expression Name] < '50%' , Red()
)
)
)
use a linear Gauge
http://livingqlikview.com/variations-on-the-linear-gauge/
Hi Vineeth,
Thanks !
I have tried the same present in your link.I am able to get the background colour equivalent to the value but cannot show the value.
I want the value also to be displayed with the background in the same cell .Can you help?
I have attached the output I am receiving
Regards,
Sahana
We cannot show both Value and gauge in same cell , you will have to add another column to show the values in it
A trick you can try is
Add a column showing values before the linear gauge and fill it with the same color and uncheck vertical expression borders in the Style tab
Thanks Vineeth