2 Replies Latest reply: Jul 7, 2014 12:26 PM by Jaime Aguilar RSS

    null value

    amir ohev shalom

      Hello all,


      I have a table column that possess multiple values, some of which appears with the symbol -, it seems to me that it is NULL.

      I want to add list box to choose the values and when it appears in the sign  - appears to me NULL for example a particular text.


      How do I do this without making a change script if possible?

      I read a bit on the subject and I left confused and would love if you could help me.



      Thanks in advance

        • Re: null value
          Diego Fernando Caivano

          Hi Amir,


          You won't be able to select null values from any chart or field because of how QlikView works.


          The only way I have analyzed and filtered null values is by replacing them previously in the script.



          • Re: null value
            Jaime Aguilar


            you can use the function NULLASVALUE. You have to go to script and type this:


            NULLASVALUE YourField;

            Set NullValue = 'N/A';


            the second line is a system variable called NullValue which lets you assign a default value to nulls. So you can set whatever text you want (instead of 'N/A'). This way when you reload script and create a listbox, you'll see that null values have been assigned with a selectable value,