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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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