Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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é

2 Replies
Highlighted
Creator
Creator

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.

Highlighted
Partner
Partner

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é