topic Bad total in straight table? in QlikView

Bad total in straight table?

Wed, 28 Jul 2010 00:03:54 GMT

I have a straight table that is displaying total at top. But when I add up the values of the 3 individual rows the total is off by 459,597,417. How can this be?

From export to excel:

Test Groups	Counters
	1,206,456,434
Test Group 1	61,380,482
Test Group 2	433,704,449
Test Group 3	1,170,968,920

Sum()	1,666,053,851
Diff	459,597,417

Bad total in straight table?

mike_garcia — Wed, 28 Jul 2010 00:14:09 GMT

Are you using a Count Distinct? Is it possible that the counted elements appear in several Test Groups?

Take the following scenario: You have ONE customer that buys in TWO Stores. If you set up a straight table to count distinctly the Customers per Store, you will have two rows (1 per Store) and 1 customer on each row, but the total would still be ONE, because it is just ONE Customer.

If you want to make the total the sum of the results of every row (Sum of Rows), specify that in the Expressions tab (in the middle right).

Hope this helps.

Mike.

Bad total in straight table?

Wed, 28 Jul 2010 15:06:56 GMT

What version are you on ?

ver 9 rel 3 had serious calculation problems

Bad total in straight table?

Anonymous — Thu, 29 Jul 2010 04:15:40 GMT

I assume there's some kind of if() statement or similar in the straight table expression. The total is evaluated on it's own and is not by default the "sum of rows" but is calculated like any other dimension and is almost certainly correct, just not what you expect in this case.

What I think you want to do is change the Total Mode under Chart Properties > Expressions to "Sum of Rows", which will give you the type of total you expect here.

Bad total in straight table?

Thu, 29 Jul 2010 17:45:16 GMT

Chart Properties > Expressions to "Sum of Rows fixed things.