Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a master dimension YEAR with 5 values (2018,2019,2020,2021,2022, by now). I want this dimension to be green in different tones or levels of brightness, but always green. I know I can assign manually a color to each dimension value. The problem is that next year, the value 2023 will be added (2024, 2025...) and I want the color to be assigned automatically to each year.
When I select colors for dimension values I can select both Only color or Color scheme. How can I create a new color scheme? I only can see de dafaults in Qlik Sense. I'm thinking in creating a new color schema selecting manually several green tones.
Thanks!
Finally, I've use argb function in the visualization color expression as follows:
argb(((my_year-min(TOTAL my_year)+1)/(max(TOTAL my_year)-min(TOTAL my_year)+1))*255,122,178,28)
I don't know how you can implement this in the Master Dimension level. But you can implement it in the chart as a color expression like:
=rgb(0, 255-((Max({1}Total Year([OrderDate])) - Max(Year([OrderDate]))) * 32), 0)
-Rob
Finally, I've use argb function in the visualization color expression as follows:
argb(((my_year-min(TOTAL my_year)+1)/(max(TOTAL my_year)-min(TOTAL my_year)+1))*255,122,178,28)