2 Replies Latest reply: Jun 27, 2016 4:12 PM by Carlos Monroy RSS

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