Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Hello
You need to use the function ColorMix1() and/or ColorMix2()
Tell me if you need more help
Regards
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%
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
Thank you! I'll give it a try