Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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!