Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
brettaustin
Contributor III
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

 

Labels (5)
1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

2 Replies
sunny_talwar

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

View solution in original post

brettaustin
Contributor III
Contributor III
Author

Thank you!  Great solution!