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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Simple Question about Stats Box

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.

2 Replies
fernandotoledo
Partner - Specialist
Partner - Specialist

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!

Not applicable
Author

Will check. Thanks for the feedback.