Re: Gradient color background in Pivot table

ArtemZadorozhnyi · ‎2024-02-15

Hi!
I'm looking for a way to apply gradient color in Qlik Sense:
1) in a pivot table based on the value (background color expression). The value is 0 to 1 (0 = green and 1 = red) with a transition point = 0.2 (it should be more red starting up from this point).

2) same for bar chart.

I've been trying using RGB() function but can't adjust it to have the transition point at 0.2.

Thanks in advance!

Antoine04 · ‎2024-02-15

Hello

You need to use the function ColorMix1() and/or ColorMix2()

Tell me if you need more help

Regards

ArtemZadorozhnyi · ‎2024-02-15

Hi! Thanks for your reply.
Colormix1 does the job, but the transition point would be at 0.5 and I try to move it to 0.2, so chart like one below will have the color transition (gr->red) at 20%

Antoine04 · ‎2024-02-15

What if you adapt your expression like :

If( [Breakage %]<0.2, ColorMix1([Breakage %],GreenLight(),Green()), If( [Breakage %]>=0.2, ColorMix1([Breakage %],RedLight(),Red()) ))

Then that will be always green if <0.2 and always red if >=0.2

View solution in original post

ArtemZadorozhnyi · ‎2024-02-15

Thank you! I'll give it a try

Gradient color background in Pivot table

General Question