Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greetings!
I need to color the background of a cell in a table, based on the color value assigned to the corresponding Master Dimension value that appears in that cell. The color value for each value of the Master Dimension is set via the Qlik Sense UI, so I don't have a table with colors for each dimension value that I can use for this.
Does anyone know how to achieve this?
Please advise.
Cheers,
++José
Create a table, set measure as Color(Valueloop(1,20)) and background color as Color(Valueloop(1,20)).
Add a Dimension Valueloop(1,20).
Now you should have a table with the master color and rgb values.
See also https://community.qlik.com/t5/New-to-QlikView/What-is-the-rgb-values-of-qliksense-default-red-blue-y... credits robwunderlich.
Thanks for the reply and sorry for not noticing your comment earlier.
As I mentioned in the text of the case description, I can not set the colors via script, because they are choosing them via the UI in the dimension. What I need is to retrieve via function the value set for that dimension value via de UI.
Cheers,
++José