Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
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
nevilledhamsiri
Specialist
Specialist
Author

Dear Members,

Could any one help me on this?

Thanks

Neville

 

Brett_Bleess
Support (Former)
Support (Former)

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.