Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
diagonjope
Partner - Creator II
Partner - Creator II

How to get the RGB color value of a Master Dimension value set via the Qlik Sense UI?

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é

Labels (3)
2 Replies
Almen
Creator II
Creator II

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.

diagonjope
Partner - Creator II
Partner - Creator II
Author

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é