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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need a accumulative in pivot table by line

I need design a chart with year and month as dimension accumulating sales in last column.

Looks like:

PivotTable_Accumulate_helpQlikView.png

Remember, sum need be only the last column.

How can i do this?

Thks for advice!

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

On the Presentation tab select the Month dimension enable Show Partial Sums for that dimension.


talk is cheap, supply exceeds demand
jvitantonio
Specialist III
Specialist III

Please check app attached.

Not applicable
Author

Nice!

Now, how can i get this value and compare with sum(sales) from current year?

PivotTable_Accumulate_helpQlikView_2.png