Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator 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
Highlighted
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
Highlighted
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))

 

Highlighted
Creator III
Creator III

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

Highlighted
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