Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bnelson111
Creator II
Creator II

Visual Colours in Straight Table Chart Expression

Good Morning. 

I have a Straight table with expressions showing ink stations by machine and the colours in the station. There are over 5000 colours to choose from. I wish to have a colour visually in the cell not necessarily by that colour ie if it says yellow does have to be yellow. was thinking of a potential table with colour RGB's which would link to text and basically apply that colour to cell. I have original output below then a macked colour applied. 

ItemMaterialStation 1Station 2
T2338SUB-W-LCS 65UV YELLOW..PROCESS YELLOW
14583SUB-C-LL410 35280 CProcess Black
T2337SUB-W-LL247 47UV YELLOW..PROCESS YELLOW
T2336SUB-W-DL247 38UV YELLOW..PROCESS YELLOW
51776SUB-W-DL247 38UV YELLOW..PROCESS YELLOW
52514SUB-W-DL247 38UV YELLOW..PROCESS YELLOW
14581SUB-C-LL410 35280 CProcess Black
52625SUB-W-DL247 38UV YELLOW..PROCESS YELLOW
51572SUB-W-PED247 38108 C-

 Sort of output.

g.png

Thanks in advance

Labels (2)
10 Replies
bnelson111
Creator II
Creator II
Author

For a colour index number say RGB(255,255,200) how do i work out the Colour index number? Have everything now working thanks, but wish to assign a specific colour to a text. Thanks Brett