DAMN YOU ZEROS AND NULLS!!!

Damn, lots of time wasted with sheets and checking!!! The Excel seems to keep fighting the almighty Qlik.

Basically I am creating a table that will show the survey form in a tabular way. I have some columns that have 0 values and other with null values.

The Qlikview has some options to treat zeros and nulls. Below is a little explanation

WHAT:
How to show the columns in a pivot table with the real values if they are zero or null. Check the question 4 (column 5)  and CODAVAL 173624 and 173626 (rows 7 and 8).

HOW:

• The default configuration comes with a set of flags that you can not set again after you have made the changes.

The result is:

Note that the question 4 is gone and that I have only one survey form shown (CODAVAL)

• Setting the configuration below

Makes the null becomes 0.

• Set hide zeros

It will make the 0s disappear:

• Last but not least, the "correct" form in this case would be:

Making the zeros shown as zeros and the null columns as null.

Now if you export the table to an Excel, and make some calculus over it, it will show the same values.

Avg, sums, etc would work as a charm on an Excel sheet.

Cheers!!