Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik__Vinodh
Partner - Creator II
Partner - Creator II

Full Accumulation on over the dimension

Dear All,

Need help one the over come the problem. Like Output Need Like Last column.

Please help me..

  

OrderDatesum(Sales)rangesum(above(sum(Sales),0,rowno()))Output Need Help
83689.150
04/10/20082555.522555.522555.52
22/10/2008400.282955.82955.8
23/10/20081598.574554.374554.37
24/10/200823973.4928527.8628527.86
26/10/2008297.1928825.0528825.05
30/10/2008155.1728980.2228980.22
31/10/20081242.130222.3230222.32
06/11/20082639.5632861.882639.56
10/11/20084952.437814.287592
30/11/20086253.9344068.2113846
01/12/2008946.0745014.28946.07
02/12/20088523.2253537.59469
03/12/20084341.1857878.6813810
10/12/20082424.9560303.6316235
21/12/2008826.9461130.5717062
27/12/2008587.1461717.7117650
29/12/200821971.4483689.1539621
1 Solution

Accepted Solutions
swuehl
MVP
MVP

I think what you are describing should be the default behaviour of QV, considering the column segments in a chart to reset the accumulation. See attached.

View solution in original post

9 Replies
swuehl
MVP
MVP

I think what you are describing should be the default behaviour of QV, considering the column segments in a chart to reset the accumulation. See attached.

tresesco
MVP
MVP

If pivot table is an option, adding Month_Year field as the first dimension could the solution.

Untitled.png

Qlik__Vinodh
Partner - Creator II
Partner - Creator II
Author

without Month Year field , it will calculate the same .......?

Qlik__Vinodh
Partner - Creator II
Partner - Creator II
Author

Thanks for reply, without month year filed it will calculate .... ?

swuehl
MVP
MVP

Not by default, but you can check in your expression for a change in month.

See attached sample.

Qlik__Vinodh
Partner - Creator II
Partner - Creator II
Author

Thanks for reply,

If I add the one more expression on the same table like QTD also it work ?

swuehl
MVP
MVP

It should work also with other expressions. How does your QTD expression look like?

Qlik__Vinodh
Partner - Creator II
Partner - Creator II
Author

Thanks a lot

Qlik__Vinodh
Partner - Creator II
Partner - Creator II
Author

thanks a lot