Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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.
Thanks..It is fixed in 10