Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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))
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...
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.