Visual Colours in Straight Table Chart Expression

[bnelson111]

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. 

Item	Material	Station 1	Station 2
T2338	SUB-W-LCS 65	UV YELLOW..	PROCESS YELLOW
14583	SUB-C-LL410 35	280 C	Process Black
T2337	SUB-W-LL247 47	UV YELLOW..	PROCESS YELLOW
T2336	SUB-W-DL247 38	UV YELLOW..	PROCESS YELLOW
51776	SUB-W-DL247 38	UV YELLOW..	PROCESS YELLOW
52514	SUB-W-DL247 38	UV YELLOW..	PROCESS YELLOW
14581	SUB-C-LL410 35	280 C	Process Black
52625	SUB-W-DL247 38	UV YELLOW..	PROCESS YELLOW
51572	SUB-W-PED247 38	108 C	-

 Sort of output.

Thanks in advance

[Gysbert_Wassenaar]

What's your question?

[bnelson111]

Need to create a lookup table with text and a RGB reference for all 5000 possible colours.

[Gysbert_Wassenaar]

What's stopping you from doing that?

[bnelson111]

Can't work out how to have the RGB code applied to the cell? I know how to link on if statement see picture below, but don't know how to write a statement to look at a table with 5000 options and apply a RGB which is set for each of the 5000 options to the cell.

[Gysbert_Wassenaar]

Have a look at this discussion where they're having fun creating fields with rgb values and mapping them to products:

https://community.qlik.com/t5/QlikView-Documents/Colors-in-Qlik/ta-p/1484386

[bnelson111]

Still stuck in linking them to the Colour text description.

[Gysbert_Wassenaar · Accepted solution]

Description of definition? Or to rephrase the question: are you talking about your data model or the chart expression property Text color?

If you have the RGB value in a field called MyColor then it's simply =MyColour. Try it as a normal expression first.

If it doesn't show a value then it's not unique for the combination of dimension values that make up the row of the straight table. You could try something like =Max(MyColor) in that case.

[bnelson111]

Making progress, have a inline table loading but cant get RGB(230,0,200) to work from inline table.

[bnelson111]

After reading post cant work out how to generate ColourIndex number from RGB.