topic Re: Dimension null where there is no count in QlikView

Dimension null where there is no count

nsm1234567 — Thu, 03 Dec 2015 07:40:15 GMT

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%

Re: Dimension null where there is no count

t_chetirbok — Thu, 03 Dec 2015 12:19:03 GMT

Hello!

Are you use field Product as Dimension or Calculated dimension?

can you share some example qvw?

Re: Dimension null where there is no count

mayankraoka — Thu, 03 Dec 2015 12:23:31 GMT

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

Regards,

Mayank

Re: Dimension null where there is no count

awhitfield — Thu, 03 Dec 2015 12:24:57 GMT

Hi Nathan,

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

HTH Andy

Re: Dimension null where there is no count

Anonymous — Thu, 03 Dec 2015 12:31:52 GMT

see this:

NULL handling in QlikView

Re: Dimension null where there is no count

awhitfield — Mon, 07 Dec 2015 09:29:51 GMT

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

Re: Dimension null where there is no count

raman_rastogi — Mon, 07 Dec 2015 09:40:40 GMT

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 .

Re: Dimension null where there is no count

nsm1234567 — Mon, 07 Dec 2015 10:49:45 GMT

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