Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
awadah25
Contributor II

Calculation in pivot table

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

01.png02.png

1 Solution

Accepted Solutions
preminqlik
Valued Contributor II

Re: Calculation in pivot table

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]

))

View solution in original post

6 Replies
MVP
MVP

Re: Calculation in pivot table

Provide sample application or sample data to work...

Highlighted
awadah25
Contributor II

Re: Calculation in pivot table

qlik example

awadah25
Contributor II

Re: Calculation in pivot table

I put it in last comment.

regards.

MVP
MVP

Re: Calculation in pivot table

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

preminqlik
Valued Contributor II

Re: Calculation in pivot table

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]

))

View solution in original post

awadah25
Contributor II

Re: Calculation in pivot table

Thanks a lot.