topic Re: How to replace 'Is Not Null' in an Expression in QlikView

How to replace 'Is Not Null' in an Expression

cliff_clayman — Mon, 27 Jun 2016 19:05:06 GMT

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

Re: How to replace 'Is Not Null' in an Expression

trdandamudi — Mon, 27 Jun 2016 20:06:13 GMT

May be as below:

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

Hope this helps...

Re: How to replace 'Is Not Null' in an Expression

CarlosAMonroy — Mon, 27 Jun 2016 20:12:32 GMT

Hi,

You can use: not IsNull() function.

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

Thanks,

Carlos