Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do below while loading the table in your script..
Load
*
From TableName
Where Len(Trim(field))>0;
Thank you! It worked.
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
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..