Pivot Table Cumulative data - Qlik Community

shraddha6369 · ‎2019-05-20

Hi ,

I have an excel with sample format and numbers for Actual and Budget. I need cumulative addition of Actual, Budget, Actual-Budget and the variance calculations till the current month(for YTD) , in the sample example its 'Apr'. And rest of the columns in pivot (Average Actual and Budget- actual )only for YTD month that is Apr only. so first four column for all the months till April(with cumulative values for the fields) and next two columns only for the month of April.

Any help will be appreciated.

Thanks

Shraddha

sunny_talwar · ‎2019-05-20

It might be easier to help if you are able to share the app where you are trying to do this.

shraddha6369 · ‎2021-10-15

Hello, Can you help with this business requirement?

https://community.qlik.com/t5/App-Development/Using-Peek-in-For-loops-Outer-and-inner-for-loop/m-p/1...

Excel is attached with sample data and expected output.

Thanks much always!

Shraddha