Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

In calculating running total, need to appear the cumulative total as at July in the total row

Dear Sunny

One more issue  am having which is how to present the cumulative total as at July in Total row. Once Aggr function is applied, it calculate the total of running total

 

Thanks

 

Neville

 

2 Replies
Highlighted
Specialist
Specialist

Re: In calculating running total, need to appear the cumulative total as at July in the total row

Dear Members,

Could any one help me on this?

Thanks

Neville

 

Highlighted
Digital Support
Digital Support

Re: In calculating running total, need to appear the cumulative total as at July in the total row

Pretty sure you need the following to help you get it sorted out:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

The only other option would be to use RowNo() or RecNo() functions in the load to force every row in the pivot table to be unique at that point, which should then make  your totals equal as well...  Hopefully I am on the right track here.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.