Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator 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
Highlighted
Specialist II
Specialist II

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
Highlighted
MVP
MVP

Provide sample application or sample data to work...

Highlighted
Creator II
Creator II

qlik example

Highlighted
Creator II
Creator II

I put it in last comment.

regards.

Highlighted
MVP
MVP

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

Highlighted
Specialist II
Specialist II

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

Highlighted
Creator II
Creator II

Thanks a lot.