Change backgroud color

[bhuprakash]

Hi Experts,

I want to change colors as per the below criteria but it is not happening by me . So please help me .

More than 0% = Green

Equal to 0% = Yellow

Below 0% = Red

[vikasonkarmahajan · Accepted solution]

Hi,

Please go through the link

https://community.qlik.com/t5/Qlik-Sense-App-Development/Change-background-color-in-pivot-table/m-p/...

Vikas

[Kushal_Chawda · Accepted solution]

Go to MTD % Change expression, expand it and in bacckground color expression, put below expression

Lets say more than 70% green, equal to 50% yellow and less than 50% red, then your expression will be.

Note: I have used column(3) as your MTD % Change  is your 3rd expression, you can change it accordingly

=if(Column(3)>0.7,lightgreen(),

if(Column(3)=0.5,yellow(),

if(Column(3)<0.5,lightred())))

[bhuprakash]

Sorry for late response. Thanks Vikas and Kush.. issue resolved.