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: 
Not applicable

Pivot Table - Running Total

Hello everybody. I have a Pivot table with three dimensions and 3 expressions.

Dimensions:

1) Customer,

2) Transaction Date,

3) Transaction Document

Expressions:

1) Value in orig.currency (column 1)

2) value in local currency (column 2)

3) Running total in local currency (column 3)

For the RUNNING TOTAL I have implemented the following formula:

if(rowno(total)=0,0,numsum(column(2),above(total column(3))))

This is to share with you, and is working, could be used in accounting spreadheet simulation etc.

Does anyone have a different approach how to achieve the same? Just taking info 😉

Best Regards,

Mangas

3 Replies
vidyut
Partner - Creator II
Partner - Creator II

You could also try using RangeSum() Function to get the running total. Good work.

Not applicable
Author

Sure, and thanks, I haven't notice that.

Anyway I had to provide this code to a friend running QV version 7.5 (don't ask, corporate policy). Also, I really don't undestand the differnce bewteen RangeSum() and NumSum(), the manual has exactly the same description, just saying that Numsum() is obsolete.

What does obsolete mean, if it is still working?

Anybody, QV transition/upgrade specialist, express your opinion ???

BR,

Mangas

bimartingo
Contributor III
Contributor III

Gentlemen, sorry but i'm not fully understanding the logic of this formula.

And i have an If question :

Suppose i want to get only the running total of  value in local currency, without showing the values im running on, i e, i want only column 3.

It really coulnd't be so complex to get a running total.

Thanks in advance.