topic Simple Question about Stats Box in QlikView

Simple Question about Stats Box

Mon, 21 Jun 2010 20:42:04 GMT

Hey,

I think this should be a relatively easy question for someone to answer...

I've loaded data into a table which I'll call "myTable", which has the fields "Field1", "Field2" and "Field3". If I create a Stats Box and set the Field to calculate on "Field2", in the "Count" field, should I not get the number of instances of the field in the table? Which is essentially the number of records/rows?

I have a case where I'm viewing a table box with all the fields in the table, and I've cleared all selections, exported the table to Excel and it shows 25,636 records... but the Count in the stats box says Count = 543,218.

Any thoughts would be appreciated.

Simple Question about Stats Box

fernandotoledo — Mon, 21 Jun 2010 21:52:40 GMT

Man, depends on your datacloud. Look for syntetic tables and see if the association between them is correct. This kind of mistake generates this kind of "Cartesian Product". You can also have a case where excel dont get all rows because a table do not show repeated rows, though the stat box count considers this rows in the calculations!

Simple Question about Stats Box

Tue, 22 Jun 2010 12:36:05 GMT

Will check. Thanks for the feedback.