topic Re: Two color Gradient in Pivot Chart in QlikView

Two color Gradient in Pivot Chart

ZoeM — Sat, 16 Nov 2024 20:29:36 GMT

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

Lisa_P — Tue, 09 Jul 2019 23:27:50 GMT

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 — Wed, 10 Jul 2019 11:26:16 GMT

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:

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 — Wed, 10 Jul 2019 23:08:43 GMT

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.