Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks.
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