Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

conditional formatting in a pivot table chart

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

1 Solution

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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.

View solution in original post

3 Replies
vishsaggi
Champion III
Champion III

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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.

Not applicable
Author

Thanks Oleg and Vishwanath..

Both are correct. it worked.