topic conditional formatting in a pivot table chart in QlikView

conditional formatting in a pivot table chart

Thu, 13 Jul 2017 15:31:07 GMT

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

Re: conditional formatting in a pivot table chart

vishsaggi — Thu, 13 Jul 2017 15:35:21 GMT

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

Re: conditional formatting in a pivot table chart

Oleg_Troyansky — Thu, 13 Jul 2017 15:37:51 GMT

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.

Re: conditional formatting in a pivot table chart

Thu, 13 Jul 2017 15:48:00 GMT

Thanks Oleg and Vishwanath..

Both are correct. it worked.