HELP!!How to adjust background fill according to the cell value in straight table

[#1]

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

[Anil_Babu_Samineni]

Could you provide sample application

[dmohanty]

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()

)

)

)

[vinieme12]

use a linear Gauge

http://livingqlikview.com/variations-on-the-linear-gauge/

[#5]

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

[vinieme12 · Accepted solution]

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

[#7]

Thanks Vineeth