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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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