Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ZoeM
Specialist
Specialist

Two color Gradient in Pivot Chart

Hi Community,

Am I able to do a two color gradient for the background of a Pivot Chart?

If rating ='Y', Yellow color cell background

if rating='Y/G', Yellow and Green cell background

Is it possible?

Any Help will be truly appreciated

Labels (3)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

Ok, so for measures, not dimensions this is possible. There is even a wizard to help out.

Go to the expression, expand to find the background color, go to the expression editor, select the File menu, then Colormix Wizard and step through.

View solution in original post

3 Replies
Lisa_P
Employee
Employee

Each dimension can be expanded and you can select Background Color where you can enter an expression.

For your example:
=If(rating='Y', yellow(), rgb(154,205,50))

 

ZoeM
Specialist
Specialist
Author

Thanks for your response Lisa.

What I am trying to achieve is a two color gradient however for the expression background in a Pivot Chart. Something similar to this in excel:

Defaults.JPG

You can see above that Jan and Feb are Green/Yellow. There is an option for gradients in Qlikview but its grayed out. Could  colormix help with this?

 

Thanks...

Lisa_P
Employee
Employee

Ok, so for measures, not dimensions this is possible. There is even a wizard to help out.

Go to the expression, expand to find the background color, go to the expression editor, select the File menu, then Colormix Wizard and step through.