Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Above and Left in Pivot Table

Hi I Have a pivot table where I'd like to do a running YTD total row but I'm unsure how to do this in a pivot.

It needs to be the same as the following in Excel;

Excel YTD.jpg

Where the YTD variance is last weeks YTD variance plus this weeks variance.

I have created the pivot table in Qlikview, I just can't get this last value in.

Qlikview YTD.jpg

Any help would be massively appreiated.

Thanks

0 Replies