Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
ZoeM
Contributor III

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
Employee
Employee

Re: Two color Gradient in Pivot Chart

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
Employee
Employee

Re: Two color Gradient in Pivot Chart

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
Contributor III

Re: Two color Gradient in Pivot Chart

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...

Employee
Employee

Re: Two color Gradient in Pivot Chart

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