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

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 (5)
10 Replies
bnelson111
Creator
Creator
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