Discussion board where members can get started with QlikView.
why the calculation in pivot table is not accurate it give a wrong number, but in straight table it's right !!
Go to Solution.
It depends on what is the level of your aggrigation,
use the following exp
((sum(QTY) + (vQty2)) * (sum([Unit Price])* (1+vSales2/100)))
((sum([Unit Cost]) * sum(QTY))) * (1+vCost2/100)
Provide sample application or sample data to work...
I put it in last comment.
There are so many information and objects in your qvw. We need to have only those two where you are trying to match!
Thanks a lot.