topic Re: Null in QlikView

Null

NavinReddy — Wed, 30 Oct 2013 07:08:51 GMT

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

Re: Null

Wed, 30 Oct 2013 07:17:26 GMT

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.

Re: Null

NavinReddy — Wed, 30 Oct 2013 09:28:06 GMT

Hi Hampus ,

Thanks for giving valuable information

Regards,

Niranjan

Re: Null

Wed, 30 Oct 2013 09:50:03 GMT

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

Re: Null

NavinReddy — Wed, 30 Oct 2013 10:39:07 GMT

Script side how to write expression to avoid Null values

Re: Null

bbi_mba_76 — Wed, 30 Oct 2013 10:43:00 GMT

Hi,

as @Hampus Andersson said, like this:

load Field1, Field2 resident Table

where len(Field1)>0;

Re: Null

NavinReddy — Wed, 30 Oct 2013 10:47:23 GMT

Hi BBI,

now i am under stand how to use that

Thanks

Niranjan