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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
jcarpenter9
Partner - Creator
Partner - Creator

Null count bug in version 9 statistics box

Since we recently upgraded to QlikVIew 9.00.7502.9 SR5, I have noticed that the "Null count" in statistics boxes always shows zero. I created a simple application that loads null values into a table. When the app is opened in version 7.52, the statistics boxes show null counts of 2 and 1 for the fields Shape and Size. But in version 9, they show zero.

Can some other developers reply as to whether or not they are seeing this behavior in version 9?

James Carpenter

Colonial Life

4 Replies
pover
Partner - Master
Partner - Master

If the problem exists in version 9, somebody already fixed it in version 10. The results look correct in version 10.00.8715.5 IR as seen below.

Regards.

johnw
Champion III
Champion III

Not working on my machine in version 9 SR5 either. It doesn't surprise me that they'd have had a bug regarding nulls, then fixed it. They handle nulls differently on 64-bit, for instance, causing us to resort to len(field)=0 instead of isnull(field). Perhaps they changed the null implementation slightly on the regular 32 bit version in version 9, and didn't think to fix the null count. Then they found it (or someone found it for them), and they fixed it in version 10.

Me, I just don't use statistics boxes. If I want to see some statistics, I make a chart. I'm probably overreacting, but it just seems like the statistics boxes are always buggy in one way or another.

pover
Partner - Master
Partner - Master

It's worth adding to my previous comment that I tested on the 64-bit version.

Like John, I also never use the statistics object. I actually even stopped teaching to make them in the QlikView classes I give because a chart is better.

Regards.

siddharth_kulka
Creator II
Creator II

Thanks..It is fixed in 10