topic Partial Sums error/bug? in QlikView

Partial Sums error/bug?

Mon, 06 Dec 2010 17:50:36 GMT

Hi guys,

Has anyone come across a possible bug when creating subtotals for a pivot table? I have a table and the partial sums is giving the wrong answer? This only occurs in one of 4 tables. In the table below, the total on the right is fine but the subtotal for each country is incorrect.

type	FRANCE	GERMANY	SPAIN	UK	HUNGARY	POLAND	Total
A	15,571,408	3,244,873	16,610,151	26,766,687	1,714,269	10,255,721	74,163,110
B	1,318,604	1,134,547	4,442,907	8,557,572	1,508,499	841,247	17,803,376
C	0	0	0	47,256	0	0	47,256
D	1,750,967	4,223,077	5,944,194	4,586,050	0	0	16,504,288
E	(208,902)	(3,134,593)	(5,035,153)	(7,844,530)	0	0	(16,223,177)
F	0	0	0	(52,157)	0	0	(52,157)
G	(1,303,678)	(46,407)	(9,716)	(839,271)	(327,287)	0	(2,526,359)
H	(4,861,895)	(1,664,617)	(987,598)	(2,663,852)	(666,163)	(106,348)	(10,950,474)
I	(4,538,203)	(471,540)	(2,214,150)	(2,773,284)	(53,810)	(24,315)	(10,075,302)
J	0	12,901	0	0	0	0	12,901
Total	100,597,010	32,664,830	164,739,054	274,378,104	21,502,014	105,706,966	699,587,978

I've tried recreating it but still coming up with odd results. Any ideas why it doesn't sum the columns as expected?

thanks

AW:Partial Sums error/bug?

brenner_martina — Mon, 06 Dec 2010 18:19:28 GMT

yes, I had this phenomenon if I had created Syn-Tables!

AW:Partial Sums error/bug?

Mon, 06 Dec 2010 18:37:03 GMT

Okay, there are no synthetic keys in my qvw though, very strange!

AW:Partial Sums error/bug?

pover — Tue, 07 Dec 2010 04:18:55 GMT

Something is wrong in the way your data model is linked or joined. Strangely the countries have totals about 10 times more than their real total and their are 10 types.

Regards.

Partial Sums error/bug?

Anonymous — Tue, 07 Dec 2010 04:46:50 GMT

I suspect that this is due to the expression and/or dimension you're using. If you upload a reduced copy of the document that would be helpful in checking.

(My guess would be that the expression contains an if() statement of some sort)