topic Null count bug in version 9 statistics box in QlikView https://community.qlik.com/t5/QlikView/Null-count-bug-in-version-9-statistics-box/m-p/241323#M91753 <HTML><HEAD></HEAD><BODY><P>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.</P><P>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.</P></BODY></HTML> Wed, 20 Oct 2010 00:56:59 GMT johnw 2010-10-20T00:56:59Z Null count bug in version 9 statistics box https://community.qlik.com/t5/QlikView/Null-count-bug-in-version-9-statistics-box/m-p/241321#M91751 <HTML><HEAD></HEAD><BODY><P>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.</P><P>Can some other developers reply as to whether or not they are seeing this behavior in version 9?</P><P></P><P>James Carpenter</P><P>Colonial Life</P><P><IMG src="file:/C:/DOCUME~1/GJDC1/LOCALS~1/Temp/moz-screenshot.png" /><IMG src="file:/C:/DOCUME~1/GJDC1/LOCALS~1/Temp/moz-screenshot-1.png" /></P></BODY></HTML> Tue, 19 Oct 2010 15:59:34 GMT https://community.qlik.com/t5/QlikView/Null-count-bug-in-version-9-statistics-box/m-p/241321#M91751 jcarpenter9 2010-10-19T15:59:34Z Null count bug in version 9 statistics box https://community.qlik.com/t5/QlikView/Null-count-bug-in-version-9-statistics-box/m-p/241322#M91752 <HTML><HEAD></HEAD><BODY><P>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.</P><P>Regards.</P></BODY></HTML> Tue, 19 Oct 2010 16:24:44 GMT https://community.qlik.com/t5/QlikView/Null-count-bug-in-version-9-statistics-box/m-p/241322#M91752 pover 2010-10-19T16:24:44Z Null count bug in version 9 statistics box https://community.qlik.com/t5/QlikView/Null-count-bug-in-version-9-statistics-box/m-p/241323#M91753 <HTML><HEAD></HEAD><BODY><P>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.</P><P>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.</P></BODY></HTML> Wed, 20 Oct 2010 00:56:59 GMT https://community.qlik.com/t5/QlikView/Null-count-bug-in-version-9-statistics-box/m-p/241323#M91753 johnw 2010-10-20T00:56:59Z Null count bug in version 9 statistics box https://community.qlik.com/t5/QlikView/Null-count-bug-in-version-9-statistics-box/m-p/241324#M91754 <HTML><HEAD></HEAD><BODY><P>It's worth adding to my previous comment that I tested on the 64-bit version.</P><P>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.</P><P>Regards.</P></BODY></HTML> Wed, 20 Oct 2010 02:24:03 GMT https://community.qlik.com/t5/QlikView/Null-count-bug-in-version-9-statistics-box/m-p/241324#M91754 pover 2010-10-20T02:24:03Z Null count bug in version 9 statistics box https://community.qlik.com/t5/QlikView/Null-count-bug-in-version-9-statistics-box/m-p/241325#M91755 <HTML><HEAD></HEAD><BODY><P> Thanks..It is fixed in 10</P></BODY></HTML> Tue, 07 Jun 2011 15:22:50 GMT https://community.qlik.com/t5/QlikView/Null-count-bug-in-version-9-statistics-box/m-p/241325#M91755 siddharth_kulka 2011-06-07T15:22:50Z