Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
alan_grn
Creator II
Creator II

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?

1 Solution

Accepted Solutions
danieloberbilli
Specialist II
Specialist II

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

Hi,

Plz check the surpress zero values property in dimension tab

Not applicable

check the option in  presentation tab >suppress zero values

danieloberbilli
Specialist II
Specialist II

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
Creator II
Creator II
Author

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