Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
alan_grn
Contributor

Zero Values in Data for CrossTab

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?

Tags (2)
1 Solution

Accepted Solutions
danieloberbilli
Valued Contributor II

Re: Zero Values in Data for CrossTab

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;

View solution in original post

4 Replies
Not applicable

Re: Zero Values in Data for CrossTab

Hi,

Plz check the surpress zero values property in dimension tab

Not applicable

Re: Zero Values in Data for CrossTab

check the option in  presentation tab >suppress zero values

danieloberbilli
Valued Contributor II

Re: Zero Values in Data for CrossTab

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;

View solution in original post

alan_grn
Contributor

Re: Zero Values in Data for CrossTab

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