topic Re: Zero Values in Data for CrossTab in QlikView

Zero Values in Data for CrossTab

alan_grn — Wed, 29 Oct 2014 12:20:25 GMT

I have a table of Data which includes data with zero values..

When I use a crosstab load the zeros are removed. How do I retain them in the data?

Wed, 29 Oct 2014 12:31:19 GMT

Hi,

Plz check the surpress zero values property in dimension tab

Wed, 29 Oct 2014 12:35:48 GMT

check the option in presentation tab >suppress zero values

danieloberbilli — Wed, 29 Oct 2014 12:37:50 GMT

Use NULLASVALUE and Set NullValue (see below)

And try to load the data first as a normal table and then afterwards as crosstab

NULLASVALUE Field1,Field2,...;

Set NullValue = 0 ;

Source:

LOAD

ID,

Field1,

Field2

FROM

xxx

CrossTable(attribute,data,1) LOAD * Resident test;

DROP Table Source;

alan_grn — Wed, 29 Oct 2014 12:46:41 GMT

Thanks. The trick was loading this again from the resident table.