Discussion board where members can learn more about Qlik Sense App Development and Usage.
unfortunately I have departments that are Null.
I need to fill in this as white, as a space to allocate
I have this colour expression in Qlik Sense
if( Trainers = '1' , Green() ,
I have tried to change it to
If(Len(Trim(Department)) = 0 , rgb(128,128,128)
Maybe you can try giving them a name at back end.
If(isnull(Department),'XX',Department as Department1,
If you want a more classy way to color departments, add a department color table to your model.
Then on front end, you can colorcode them without using IF.
Should be joy, joy, joy then
Thanks for your help, but used a different method.
,if(IsNUll([Department]), 'NotStated', [Department]) as [Department Main]