Suppress null values in charts

[#1]

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

[MK_QSL]

Do below while loading the table in your script..

Load

     *

From TableName

Where Len(Trim(field))>0;

[#3]

Thank you! It worked.

[#4]

Sorry, there is a problem, that does work but that removes the rows with missing values from the data. I want them to remain in the data set but not show in the charts.

Is there another solution?

Best wishes

[MK_QSL]

Load    

     *,

     If(IsNull(Field) or Len(Trim(Field))=0, Null(), Field) as Field

From TableName;

Now use the Suppress When Value is Null in your Table/Chart for Field Dimension and let me know whether your problem solved or not..