topic Re: Visual Colours in Straight Table Chart Expression in QlikView

Visual Colours in Straight Table Chart Expression

bnelson111 — Sat, 16 Nov 2024 20:14:37 GMT

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

Re: Visual Colours in Straight Table Chart Expression

Gysbert_Wassenaar — Tue, 20 Aug 2019 10:08:47 GMT

What's your question?

Re: Visual Colours in Straight Table Chart Expression

bnelson111 — Tue, 20 Aug 2019 11:43:30 GMT

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

Re: Visual Colours in Straight Table Chart Expression

Gysbert_Wassenaar — Tue, 20 Aug 2019 12:16:55 GMT

What's stopping you from doing that?

Re: Visual Colours in Straight Table Chart Expression

bnelson111 — Tue, 20 Aug 2019 12:31:38 GMT

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.

Re: Visual Colours in Straight Table Chart Expression

Gysbert_Wassenaar — Tue, 20 Aug 2019 13:00:16 GMT

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

Re: Visual Colours in Straight Table Chart Expression

bnelson111 — Tue, 20 Aug 2019 13:28:43 GMT

Still stuck in linking them to the Colour text description.

Re: Visual Colours in Straight Table Chart Expression

Gysbert_Wassenaar — Tue, 20 Aug 2019 14:13:21 GMT

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.

Re: Visual Colours in Straight Table Chart Expression

bnelson111 — Fri, 23 Aug 2019 14:30:27 GMT

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

Re: Visual Colours in Straight Table Chart Expression

bnelson111 — Fri, 23 Aug 2019 14:43:14 GMT

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

Re: Visual Colours in Straight Table Chart Expression

bnelson111 — Mon, 26 Aug 2019 08:56:27 GMT

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