topic Re: sum total error in table in QlikView

sum total error in table

ecabanas — Thu, 16 Jul 2015 10:30:15 GMT

Hi,

I have an error in total cost field. The TOTAL in cost field did not sum correctly,

Anyone knows how to fix it?

Many thank's

Re: sum total error in table

Kushal_Chawda — Thu, 16 Jul 2015 10:34:32 GMT

What is the error?

Re: sum total error in table

swuehl — Thu, 16 Jul 2015 10:36:26 GMT

Try

sum( Aggr(

(sum ({<CalendarYear =,CalendarMonthName=,CalendarMonthAndYear={">=$(=addmonths(max(CalendarMonthAndYear),-1200)) <=$(=Max(CalendarMonthAndYear))"}>} UNIDADES)*-1)

Avg ({<CalendarYear =,CalendarMonthName=,CalendarMonthAndYear={">=$(=addmonths(max(CalendarMonthAndYear),-1200)) <=$(=Max(CalendarMonthAndYear))"}>} WAC)

,DES_FAMILIA,DES_SUB1,DES_SUB2,ITEMID,ITEMNAME)

)

Re: sum total error in table

ecabanas — Thu, 16 Jul 2015 10:37:02 GMT

Hi Kush

Sorry the error is inside the doc. The TOTAL in cost field did not sum correctly,

Re: sum total error in table

ecabanas — Thu, 16 Jul 2015 10:41:13 GMT

Hi swuehl

If I apply your formula, see that there are some lines not multiplying:

Re: sum total error in table

Kushal_Chawda — Thu, 16 Jul 2015 10:43:19 GMT

Hi,

You need to aggregate it by all the dimensions of the pivot table.

Please see the attached

Re: sum total error in table

swuehl — Thu, 16 Jul 2015 10:46:21 GMT

Can't reproduce your data, have you changed the selection compared to the uploaded version?

edit: third line shows only 5 units at my version, and it does multiplicate to cost

Re: sum total error in table

ecabanas — Thu, 16 Jul 2015 11:00:56 GMT

Hi swuehl

Yes I update the date but the problem is the same, there are 6 units, cost, but not multiplies and I don't know why

Re: sum total error in table

ecabanas — Thu, 16 Jul 2015 11:01:34 GMT

Hi Kush

Now it sums but there are some lines not multiplying, you know why?

Many thank's

Re: sum total error in table

swuehl — Thu, 16 Jul 2015 11:05:06 GMT

What do you mean 'I update the date', have you reloaded it?

I do get a full set of cost and total with your original file.

Family	DES_SUB1	DES_SUB2	ITEMID	ITEMNAME	Units	Avg WAC	Cost
Total					11	9,51	79,31
08.BEBE E INFANTIL	14.VIAJE	06. BASES Y FIJADORES DE SILLA	10363680	BASE BEBE CONFORT 2WAYFIX NEGRA	0	127,60	0,00
			10363787	PARASOL ENROLLABLE BEBE CONFORT	1	8,03	8,03
			10363788	KIT DE VIAJE BEBE CONFORT	5	10,20	51,00
			10363789	RETROVISOR BEBE CONFORT	0	2,55	0,00
			10363790	REPOSACABEZAS DE VIAJE BEBE CONFORT	5	4,05	20,27

To see you issue, please describe what you have changed or upload a new sample file.

Re: sum total error in table

Kushal_Chawda — Thu, 16 Jul 2015 11:09:00 GMT

which lines? can you show the screenshot?