topic Re: Help with background color gradient in pivot table in QlikView

Help with background color gradient in pivot table

amit_shetty78 — Thu, 19 Apr 2018 15:29:09 GMT

Hi,

I am trying to implement background color gradient based on an expression values in a pivot chart. I would like to get the pivot to look like this:

Lowest value is Red and max is green. All +ve values are shades of green and -ve values shades of red.

Also the values are formatted to show as '#.00%' but the shading is based on the exact values. That's why you can see that some of the cell have a shade even though the value appears to be '0.00%'. (as shown in the 2nd screen grab attached.

Any help on how I can achieve this in my chart. I have played around with colormix but cant get it to work as required.

Thank you.

Re: Help with background color gradient in pivot table

Anil_Babu_Samineni — Thu, 19 Apr 2018 15:30:10 GMT

Look https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/ColorFunctions/ARGB.htm

QlikView Technical Brief - RGB() and ARGB() when to use each.zip

Re: Help with background color gradient in pivot table

YoussefBelloum — Thu, 19 Apr 2018 15:34:36 GMT

Hi,

you should be able to get the desired output using the Colormix() function.

there is a wizard dedicated to help generate the coloring expression.

share with us your expression

Re: Help with background color gradient in pivot table

fvelascog72 — Thu, 19 Apr 2018 15:51:07 GMT

Hi,

You have to use ColorMix2()

This is an example:

Saludos

Re: Help with background color gradient in pivot table

amit_shetty78 — Thu, 19 Apr 2018 16:16:57 GMT

Thanks guys.

I was using colormix but was configuring the intermediate value incorrectly.

Managed to fix it.

This is the working expression:

ColorMix2 (if($(vCountryDurationDiff)<Num(0,'#,##.00%'),-Sqrt(-($(vCountryDurationDiff)-Num(0,'#,##.00%'))/(Num(0,'#,##.00%')-RangeMin (top(total $(vCountryDurationDiff),1,NoOfRows(total))))),Sqrt(($(vCountryDurationDiff)-Num(0,'#,##.00%'))/(RangeMax (top(total $(vCountryDurationDiff),1,NoOfRows(total)))-Num(0,'#,##.00%')))), ARGB(255, 248,105,107), ARGB(255, 99,190,123), ARGB(255, 255, 255, 255))

Thanks.

Re: Help with background color gradient in pivot table

Anil_Babu_Samineni — Fri, 20 Apr 2018 00:22:29 GMT

This is the difficult to say without knowing your original expression.. I suggest you to do using If...Else with BG color one for ARGB() for Light shade.

Re: Help with background color gradient in pivot table

JRamos — Tue, 15 Feb 2022 21:33:39 GMT

Hi!

I'm trying to do something similar, but I can't, needs to be similar to my old tableau table, my measure is: count(distinct([Unique Value])).

The max number is the red one and min number should be gray

Old tableau table

New pivot table in QlikSense

Can you guide me, thanks in advance!