topic Re: Assigning a Colour to a dimension via the load script in QlikView

Assigning a Colour to a dimension via the load script

gavin_kite — Tue, 29 May 2018 16:04:08 GMT

Hi Guys

This feels really basic but I'm struggling to assign a colour to a dimension

I've added the RGB value that I want to use for each Requirement Part ID

And need to colour the 'Requirement Part ID' with the RGB colour to the right

I have expanded the Requirement Part ID dimension and in the Background Colour field have tried loads of different thing already suggested on here and none of them seem to work unless you only have one Requirement Part ID value selected. I would like it to show the RGB colour if a Requirement Part ID is selected or not

Things already tried:

=$(=only(PartColour))
=$(=$(=PartColour))
=PartColour
PartColour

I've also tried all of the above as a variable.

You can see it is working fine when only a single Requirement Part ID is selected. This is using =$(=$(=PartColour)) but as soon as the Requirement Part ID selection is removed, I lose the colour

Any ideas on what else I could try?

Thanks

Re: Assigning a Colour to a dimension via the load script

sunny_talwar — Tue, 29 May 2018 16:07:46 GMT

May be look here

Maintaining Color of the Dimensions in QlikView – Learn QlikView

Re: Assigning a Colour to a dimension via the load script

gavin_kite — Tue, 29 May 2018 16:10:15 GMT

Thanks for your response but that seems to refer to setting colour by expression?

My code does work on the dimension but only when single value is selected

Re: Assigning a Colour to a dimension via the load script

sunny_talwar — Tue, 29 May 2018 16:12:51 GMT

Instead of storing the whole thing, store it as three fields.... R, G, B and then use this

RGB(R, G, B) as the expression for Dimension color and see if that works

Re: Assigning a Colour to a dimension via the load script

gavin_kite — Tue, 29 May 2018 16:37:26 GMT

Worked a treat. Thank you