conditional formatting in a pivot table chart

[#1]

Hi,

I would like to implement a Red and Green colour based on my target in my pivot table chart. Can someone please help me how to do this in Qlikview.

thanks a lot in advance

Sowjnaya

[vishsaggi]

What are your threshold values for the colors Red and Green. Write an expression like click on + sign on the expression then in the BackgroundColor format double click to open the expr editor and write

= IF(yourexpression < 0.95, Red(),

   IF(yourexpression >= 0.95 and yourexpresion < 0.98, Yellow(),

   IF(yourexpression >= 0.98, Green() )))

[Oleg_Troyansky · Accepted solution]

Open the additional Expression attributes - the little "+" next to the Expression name, and configure the Background Color and the Text color. For example:

IF(Actual>$(vTarget), green(), red())

cheers,

Oleg Troyansky

Upgrade your Qlik skills with my book  QlikView Your Business - An expert Guide to QlikView and Qlik Sense.

[#4]

Thanks Oleg and Vishwanath..

Both are correct. it worked.