Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik__Vinodh
Partner
Partner

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.

View solution in original post

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
Partner
Author

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

Qlik__Vinodh
Partner
Partner
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
Partner
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
Partner
Author

Thanks a lot

Qlik__Vinodh
Partner
Partner
Author

thanks a lot