Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This forum is where any logged-in member can create a knowledge article.
Hi qlik community members, 👋
Check out this solution to create your own gradient color palette with the ColorMix2() function.
Let's see how we can achieve this result, in a simple data model.
1 – Find the largest and smallest value of your measurement.
max(total aggr(Sum([Total value]),Customer))
min(total aggr(Sum([Total value]),Customer))
2 – Calculate the difference between these values
max(total aggr(Sum([Total value]),Customer))
-
min(total aggr(Sum([Total value]),Customer))
3 – Now we will create a range, where we will identify positions 0 and 1 of the indices, or basically the values from 0% to 100%.
(sum([Total amount])
-
min(total aggr(Sum([Total amount]),Customer)))
/
(max(total aggr(Sum([Total amount]),Customer))
-
min(total aggr(Sum([Total amount]),Customer)))
4 – To apply the gradient, in your graph go to the Presentation window -> Colors and Legend -> Colors Customize by expression. In the check box, leave the option selected as shown below:
5 – Finally, in the expression insert your calculation within the ColorMix2() function.
ColorMix2((sum([Total amount])
-
min(total aggr(Sum([Total amount]),Customer)))
/
(max(total aggr(Sum([Total amount]),Customer))
-
min(total aggr(Sum([Total amount]),Customer))),red(),blue(),yellow())
For more details see this and other color functions in the qlik help.
https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/ColorFunctions/color-functions-charts.htm
I hope you like it! 🙂
Attached is the qvf for anyone who wants to see the example model exposed.
Yours sincerely, Matheus
Dear Community,
I am sharing this document as I was always searching for list of all Qlik Chart functions in order for learning purpose. I couldn't find so I have created a list of all the chart functions available in Qlik. All the functions are available in Qlik but just in case if you want an ordered list.
I hope this will be helpful.
Best Regards,
Arpit Vijay