Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Need a accumulative in pivot table by line

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


talk is cheap, supply exceeds demand
jvitantonio
Valued Contributor III

Re: Need a accumulative in pivot table by line

Please check app attached.

Not applicable

Re: Need a accumulative in pivot table by line

Nice!

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

PivotTable_Accumulate_helpQlikView_2.png

Community Browser