Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

cliff_clayman
Contributor

How to replace 'Is Not Null' in an Expression

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

2 Replies
trdandamudi
Honored Contributor

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

May be as below:

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

Hope this helps...

CarlosAMonroy
Contributor III

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

Hi,

You can use: not IsNull() function.

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

Thanks,

Carlos

Community Browser