Pivot table background color based on cell value

ramyasaiqv — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I’m not sure what’s wrong with my expression, please can someone help me?

Based on the cell value the back ground color should change as follows:

Here is the expression I have written:

if(MXT_Data='N/A',rgb(211,211,211),

if(MXT_Data >=1 and MXT_Data <2,LightRed(),

iF(MXT_Data >=2 and MXT_Data <3,rgb(255,165,0),

if(MXT_Data>=3 AND MXT_Data<4,Yellow(),

if(MXT_Data>=4 and MXT_Data<=4.5,rgb(34,139,34), Blue()

)))))

The requirement:

If MXT_Data =’N/A’ then –Grey

if(MXT_Data >=1 and <2 – Red

iF(MXT_Data >=2 and ❤️ –Orange

if(MXT_Data>=3 and <4- Yellow

if(MXT_Data>=4 and <=4.5 –Green otherwise Blue

Re: Pivot table background color based on cell value

rubenmarin — Sun, 27 Aug 2017 18:11:40 GMT

Hi Ramya, the value in the table is calculated, but the color expression only cheks the field, maybe setting the same expression in the color expression? PFA.

Re: Pivot table background color based on cell value

ramyasaiqv — Sun, 27 Aug 2017 18:40:32 GMT

That worked. Thank you so much Ruben.

Regards,

Ramya

topic Re: Pivot table background color based on cell value in QlikView

Pivot table background color based on cell value

Re: Pivot table background color based on cell value

Re: Pivot table background color based on cell value