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

Pivot Table

is it possible to have in a pivot table one row with a progressive values?

e.g.

jan feb mar apr

10 -5 20 10

prg 10 5 25 35

thanks a lot

gabriele

4 Replies
Not applicable
Author

Can you please be more clear.

Not applicable
Author

Yes i beg your pardon

in a pivot table i have the total with

e.g four month

jan feb mar apr

10 -5 10 20

i want a row with the progressive values in the various month

10 -5 15 35

thanks a lot

Not applicable
Author

aammRataTotal201001201002201003201004201005201006201007201008201009201010201011201012201101
-654.279-1.964.401-1.246.5812.086.5195.190.6135.701.1104.550.5785.746.7527.750.80710.251.03512.474.40912.574.43112.587.894
12.587.894-654.279-1.310.122717.8193.333.1003.104.095510.497-1.150.5321.196.1732.004.0552.500.2282.223.374100.02213.463

i want if is possible to obtain the yellow row who is cumulative values of the total row

Thanks a lot

Not applicable
Author

You can make use of "Cumulative" function under Expression Tab to achieve the above result.

Regards

Rajesh