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:
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
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
May be look here
Maintaining Color of the Dimensions in QlikView – Learn QlikView
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
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
Worked a treat. Thank you