Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
techvarun
Specialist II
Specialist II

Problem in finding the total

Hi all

                   I have a pivot table with year quarter and month i have computed total profit for monthwise and i need to show the total of all the three month value in last column.

14 Replies
techvarun
Specialist II
Specialist II
Author

I have attached the qvw please check

alexandros17
Partner - Champion III
Partner - Champion III

Hi techvarnun,

I've worked with your qvw, the result is that you must add the following expression (After Total):

aggr(NODISTINCT Sum({<Category={'Revenue'}>} [Exchange Rate]*[Total (Amount)]) - Sum({<Category={'Costs'}>} [Exchange Rate]*[Total (Amount)]) ,Category, Type, Year, Quarter)

This expression add a new column where all rows have total of quarter, if you need only one row with the total (but not a new row) delete NODISTINCT

Hope it helps

nizamsha
Specialist II
Specialist II

see the attachment

techvarun
Specialist II
Specialist II
Author

Sorry am on my qlikview personal edition


Regards

nizamsha
Specialist II
Specialist II

IS that u want u want to add app+may+june and it should display in the next row

in presenttion enable show partical sums to month