4 Replies Latest reply: Sep 19, 2014 8:43 AM by Manish Kachhia RSS

    Suppress null values in charts

    Katie Rushforth


      I'm struggling with null values and hope someone can help. 


      I have used :

      SET NullInterpret= '';

      SET NullInterpret = ;


      and I have used the following on each variable:

      If(Len(Trim(field))>0,field) ,


      I have set all my charts to 'Suppress When Value Is Null'.

      I am still getting null values in my charts.  I do not get a null field or additional colour in the legend but in the chart itself there is a 3rd gender or additional null variable count.


      I created the file in SPSS and saved as a csv file.  I have imported the csv file into qlikview.  I have never had this happen before using this method.


      Please can somebody help?