Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
nsm1234567
Creator II
Creator II

Dimension null where there is no count

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.

 

ProductUnitsUnit %
400        100%
Product110025.00%
Product210025.00%
Product310025.00%
Product410025.00%
-00.00%
1 Solution

Accepted Solutions
awhitfield
Partner - Champion
Partner - Champion

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

View solution in original post

7 Replies
t_chetirbok
Creator III
Creator III

Hello!

Are you use field Product as Dimension or Calculated dimension?

can you share some example qvw?

mayankraoka
Specialist
Specialist

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

Regards,

Mayank

awhitfield
Partner - Champion
Partner - Champion

Hi Nathan,

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

HTH Andy

Anonymous
Not applicable

awhitfield
Partner - Champion
Partner - Champion

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
Partner - Creator III
Partner - Creator III

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

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