topic Re: Calculation in pivot table in QlikView

Calculation in pivot table

Anonymous — Sun, 25 Oct 2015 07:55:37 GMT

why the calculation in pivot table is not accurate it give a wrong number, but in straight table it's right !!

MK_QSL — Sun, 25 Oct 2015 08:16:00 GMT

Provide sample application or sample data to work...

Anonymous — Sun, 25 Oct 2015 08:39:53 GMT

qlik example

Anonymous — Sun, 25 Oct 2015 08:40:49 GMT

I put it in last comment.

regards.

MK_QSL — Sun, 25 Oct 2015 08:45:23 GMT

There are so many information and objects in your qvw. We need to have only those two where you are trying to match!

preminqlik — Sun, 25 Oct 2015 08:56:17 GMT

hi there,

It depends on what is the level of your aggrigation,

use the following exp

=sum(aggr(

((sum(QTY) + (vQty2)) * (sum([Unit Price])* (1+vSales2/100)))

(

((sum([Unit Cost]) * sum(QTY))) * (1+vCost2/100)

)

[Customer Name],

[SOP Number],

Item_Description,

[S_Location Code]

))

Anonymous — Sun, 25 Oct 2015 10:03:43 GMT

Thanks a lot.