13 Replies Latest reply: Feb 24, 2015 12:20 PM by Rakesh Ranjan RSS

    Dealing with null value in variable (inputbox)

      Hi guys

       

      I just think that variable management isn't developed good enough in Qlikview or I just can't get it right (maybe the second affirmation is more probable) .

       

      I get one variable defined in an input box and want to do some calculations with it and null case is a big deal for me, I attached a qvw file to illustrate the situation at a basic level but the expressions I'm using are:

      - Left text box: =If($(=len(vVariable))=0, 'Empty', $(vVariable)) => Works good, shows variable value without a problem and 'Empty' when null

       

      - Right text box: =If($(=len(vVariable))=0, 'Empty', 'Value: '&$(vVariable)) => Works good with value, when null I get Expression Error (as you first see)

       

      This is pretty basic but if you replace the else case by another if condition using the vVariable get the same issue.

       

      Do you know how can I correctly handle null value on this case?

       

      Thanks