Show null values as

[MK9885]

Hello,

I would like to show blank or null values as 'InProcess'

I'm working on Qlik Sense, not Qlik View.

Ex: If there are 2 values in a filed, A and B the third value is Blank. So instead of blank I want to show InProcess on Bar.

I've tried multiple If condition and also IsNull but couldn't make it work.

stalwar1‌

Thanks.

[MK9885]

I got it...

with both scrips I tested and it's giving same result. I was using wrong measure so I wasn;t getting the null value as Inprocess.

LOAD DimensionName1,

          If(Len(Trim(DimensionName1)) = 0, 'InProcess', DimensionName1)  as DimensionName1_New

FROM ....

Or we can use this as well

LOAD Dim,

          if(isnull(Dim)< 0,'InProcess',Dim)  as Dim1

FROM....

Thanks stalwar1‌