Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Suppress null values in charts

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

4 Replies
MVP
MVP

Re: Suppress null values in charts

Do below while loading the table in your script..

Load

     *

From TableName

Where Len(Trim(field))>0;

Not applicable

Re: Suppress null values in charts

Thank you! It worked.

Not applicable

Re: Suppress null values in charts

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

MVP
MVP

Re: Suppress null values in charts

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..