Null

[NavinReddy]

Hi All,

Some one help me how to avoid null values in qlikview and

What is the use of Suppress Zero Values?

Where Can we using Suppress Zero Values ?

Some one help me This Scenario

Thanks In Advance

Niranjan

[#2 · Accepted solution]

You can remove null values when you do the load by using a where statement (ex. where len(fields >0); ).

The suppress zeros are useful when you don't like to show zeros in your chart for some reason. Activate it will make the chart ignore null and zero values.

[NavinReddy]

Hi   Hampus ,

Thanks for giving valuable information

Regards,

Niranjan

[#4]

Suppress Zero values if not enabled, Then the chart will show the zeros values in the data. If you ont want to display the zero values in your table/chart then just Enable Suppress zero values and all the zero values values in your table will not be displayed

[NavinReddy]

Script side how to write expression to avoid Null values

[bbi_mba_76]

Hi,

as @Hampus Andersson said, like this:

load Field1, Field2 resident Table

where len(Field1)>0;

[NavinReddy]

Hi BBI,

now i am under stand how to use that

Thanks

Niranjan