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

    Suppress null values in charts

    Katie Rushforth

      Hi,

      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?

       

      Thanks