Dimension null where there is no count

[nsm1234567]

Hey There,

I have a question about how Qlikview does calculations in a straight table.  I have a table that looks as below.  You'll see there's a fifth entry "Null" even though there is no unit count or unit percentage.  I know that I can suppress this Null, but I'm trying to understand why it shows up in the first place?  Is there something specific to certain data models that causes this to happen?  The expression is a simple sum of the Units field without any set analysis.

Product	Units	Unit %
	400	100%
Product1	100	25.00%
Product2	100	25.00%
Product3	100	25.00%
Product4	100	25.00%
-	0	0.00%

[t_chetirbok]

Hello!

Are you use field Product as Dimension or Calculated dimension?

can you share some example qvw?

[mayankraoka]

It may be due to the data it has blank value.Please check data.

Regards,

Mayank

[awhitfield]

Hi Nathan,

can you upload a sample QVW? It saves people having to guess.

HTH Andy

[Anonymous]

see this:

NULL handling in QlikView

[awhitfield · Accepted solution]

Just looks like you have numerous LInkID numbers with a product type of 'Missing' which have zero sales data., if you don't want these to display in the chart, then tick 'Suppress Zero-Value) on the presentation tab

HTH

Andy

[raman_rastogi]

You can suppress null value that you already know or if you want to change place of zero in table then you can do sort .

[nsm1234567]

Hi Andrew,

Thanks a lot.  It appears as though someone switched off the "Suppress Zero-Value" option on the chart and I didn't think to check that.  That resolves my issues.

Regards

Nathan