How to replace 'Is Not Null' in an Expression

[cliff_clayman]

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])

[trdandamudi]

May be as below:

If([Division]="A" And Len(Trim([Total$])) > 0,[LocationNumber] & ":" & [LocationName],[LocationNumber])

Hope this helps...

[CarlosAMonroy]

Hi,

You can use: not IsNull() function.

If([Division]="A" And Not isNull([Total$]),[LocationNumber],[LocationNumber])

Thanks,

Carlos