Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an expression that was used in Access that I am trying to re-create in Qlik. I am not sure what to replace 'Is Not Null' with in the expression. Here is the expression:
If([Division]="A" And [Total$] Is Not Null,[LocationNumber] & ":" & [LocationName],[LocationNumber])
May be as below:
If([Division]="A" And Len(Trim([Total$])) > 0,[LocationNumber] & ":" & [LocationName],[LocationNumber])
Hope this helps...
Hi,
You can use: not IsNull() function.
If([Division]="A" And Not isNull([Total$]),[LocationNumber],[LocationNumber])
Thanks,
Carlos