Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
brettaustin
New Contributor III

Color Null Value for Dimension - Variable

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

 

1 Solution

Accepted Solutions

Re: Color Null Value for Dimension - Variable

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))

2 Replies

Re: Color Null Value for Dimension - Variable

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))

brettaustin
New Contributor III

Re: Color Null Value for Dimension - Variable

Thank you!  Great solution!