Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Partial sum Of pivot table not correct

Hello,

     I have pivot table with dimension 1)Segment 2) market segment 3)Group/Non-Group .

when we have  two usd and kes currency.when we select usd then local sales Value converted in usd currency &

Export Sales value as it is.

    

     When  we take partial sum of market segment for both local & export  it is showing incorrect total.ans also segment total is incorrect.

I have attached pivot table image pls find it below.

     pls help out me in this.

Thanking u.

1 Reply
Not applicable
Author

sum(aggr(sum(Value),Dimension1,Dimension2,Dimension3,Dimension4))

for the all three expressions