topic Color Null Value for Dimension - Variable in QlikView

Color Null Value for Dimension - Variable

brettaustin — Sat, 16 Nov 2024 20:57:27 GMT

Hello People...

Basic color question. I have dimensional data with 'Null Values'. I want to color my chart based on the dimensions. I created a variable to color code it, however I can not seem to assign a color to the 'Null Value' RGB (150, 150, 150) - I do not want black. Any ideas? See attached for example

Re: Color Null Value for Dimension - Variable

sunny_talwar — Wed, 01 May 2019 11:55:13 GMT

May be load your data like this
If(Len(Trim(CurrentStatus)) = 0, ' ', CurrentStatus) as CurrentStatus,

and change the color to this
pick(match(CurrentStatus,
'BC0','BC1','BC2','BC3','BC4','BC5')+1, RGB (150, 150, 150),
rgb(239,149,149),rgb(239,218,149),rgb(185,231,149),rgb(149,231,235),rgb(149,158,239))

Re: Color Null Value for Dimension - Variable

brettaustin — Wed, 01 May 2019 13:13:24 GMT

Thank you! Great solution!