topic Pivot table in QlikView

Pivot table

Fri, 22 Apr 2011 14:37:35 GMT

Hello

i have a probleme with the sum in the pivot table.

Chantier	Genre	Type	Serie	Cout du matériel 13 650	Prix	Nombre Engin 39
Total				13650	350	39
CARRIERE ROMMANA GABES	Total			13650	350	39
	PELLE	Total		1050	350	3
	PELLE	R170	N50311847	1050	350	3
	CHARGEUSE	Total		0	0	18
	CHARGEUSE	HL770	LBO411256	0	0	18
	GROUPE ELECTROGENE	Total		0	0	18
	GROUPE ELECTROGENE	3406	9ES2419	0	0	18

i have a problem with the sum of the table.

the logic total is (3*350=1050)

but QV recalculate the sum in the total of the expression in the end of dimension ( 39 * 350 = 13650) but the right sum of the first (1050+0+0))

how can i correct it

thanks

Pivot table

Fri, 22 Apr 2011 16:42:58 GMT

do not use sum() function in "Prix" and "Nomber Engin 39".......

just use it as it is ,means just field name without any function.

regards,

Dixit

Pivot table

pover — Fri, 22 Apr 2011 17:22:28 GMT

If the column "Prix" has a sum and "Nombre Engin 39" has a sum you can't use a sum(Prix * Nombre Engin 39) anyway. Use the expression within "Prix" and "Nombre Engin 39" and make sure it is a sum(x*y) and not a sum(x)*sum(y).

Regards.

Pivot table

Fri, 22 Apr 2011 23:50:24 GMT

Hi,

thank you for yours responses .

in the begening i would to explain the goal of the table: i want to calculate the cost of rent of the cars, So this cost is the number of the day ( Nombre Engin) * the price of the day ( Prix).

when i execute your recommendations, i have this results :

Chantier	Genre	Type	Serie	Cout du matériel 23 450	Prix	Nombre Engin 67
Total				23450	350	67
RVE 543 CHOUTRANA	Total					28
	CHARGEUSE	Total				28
	CHARGEUSE	938F	2RM1120			28
CARRIERE ROMMANA GABES	Total			13650	350	39
	GROUPE ELECTROGENE	Total				18
	GROUPE ELECTROGENE	3406	9ES2419			18
	CHARGEUSE	Total				18
	CHARGEUSE	HL770	LBO411256			18
	PELLE	Total		1050	350	3
	PELLE	R170	N50311847	1050	350	3

the expression is

*Prix = Prix

* Nombre Engin= count(Suivi_Engin.Journee)

* Cout du matériel= Prix * count(Suivi_Engin.Journee)

so the problem, i don't have the number of day of rent, i count this in the table.

I 'm waiting for your helps

Thank you.