Discussion Board for collaboration related to QlikView App Development.
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?
Go to Solution.
Use NULLASVALUE and Set NullValue (see below)
And try to load the data first as a normal table and then afterwards as crosstab
Set NullValue = 0 ;
CrossTable(attribute,data,1) LOAD * Resident test;
DROP Table Source;
View solution in original post
Plz check the surpress zero values property in dimension tab
check the option in presentation tab >suppress zero values
Thanks. The trick was loading this again from the resident table.