Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculation on Partial Sum

Greetings

Please help to calculate the difference of the partial sum on Pivot table.

Please advise how can I calculate the difference between the sum of 1st column vs 2nd column and so on on a Pivot Table.

Thanks!!

1 Solution

Accepted Solutions
Specialist III
Specialist III

HI,

t

use above function

Ex:

Sum(sales)-above(sum(sales))

View solution in original post

7 Replies
Specialist III
Specialist III

HI,

t

use above function

Ex:

Sum(sales)-above(sum(sales))

View solution in original post

Not applicable

Thanks Sunny!

But unfortunately it's not working.

Please find attach the qvw file.

Thanks.

Specialist III
Specialist III

Hi,

PFA , see the last column

Not applicable

Thanks Sunny.

Is it possible if only last column will be displayed?

Thanks.

Specialist III
Specialist III

HI,

i don`t think so , it will apply on all columns

By last column you mean just the totals column?

Not applicable

Yes. Just the total column.

Thanks.