topic Re: Colour a null in App Development

Colour a null

joeybird — Tue, 03 Nov 2015 11:37:38 GMT

Hiya

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

IF(ISNULL(Department),rgb(128,128,128)

))

no joy

I have tried to change it to

If(Len(Trim(Department)) = 0 , rgb(128,128,128)

no joy

please help

Anonymous — Tue, 03 Nov 2015 11:50:49 GMT

Hello Joanna,

Maybe you can try giving them a name at back end.

Like;

LOAD

If(isnull(Department),'XX',Department as Department1,

FROM DATASOURCE;

If you want a more classy way to color departments, add a department color table to your model.

Like;

LOAD

Department,

Red_Dept,

Green_Dept,

Blue_Dept

FROM DATASOURCE;

Then on front end, you can colorcode them without using IF.

Like;

=RGB(Red_Dept,Green_Dept,Blue_Dept)

Should be joy, joy, joy then

Serhan

joeybird — Mon, 09 Nov 2015 12:35:09 GMT

Hiya

Thanks for your help, but used a different method.

,if(IsNUll([Department]), 'NotStated', [Department]) as [Department Main]

Kind Regards