topic Re: Gradient color background in Pivot table in App Development

Gradient color background in Pivot table

ArtemZadorozhnyi — Thu, 15 Feb 2024 13:28:37 GMT

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!

Re: Gradient color background in Pivot table

Antoine04 — Thu, 15 Feb 2024 13:35:57 GMT

Hello

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

Tell me if you need more help

Regards

Re: Gradient color background in Pivot table

ArtemZadorozhnyi — Thu, 15 Feb 2024 15:13:47 GMT

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%

Re: Gradient color background in Pivot table

Antoine04 — Thu, 15 Feb 2024 15:25:26 GMT

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

Re: Gradient color background in Pivot table

ArtemZadorozhnyi — Thu, 15 Feb 2024 15:39:07 GMT

Thank you! I'll give it a try