QlikView App Dev

[Qlik__Vinodh]

Dear All,

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

Please help me..

OrderDate	sum(Sales)	rangesum(above(sum(Sales),0,rowno()))	Output Need Help
	83689.15	0
04/10/2008	2555.52	2555.52	2555.52
22/10/2008	400.28	2955.8	2955.8
23/10/2008	1598.57	4554.37	4554.37
24/10/2008	23973.49	28527.86	28527.86
26/10/2008	297.19	28825.05	28825.05
30/10/2008	155.17	28980.22	28980.22
31/10/2008	1242.1	30222.32	30222.32
06/11/2008	2639.56	32861.88	2639.56
10/11/2008	4952.4	37814.28	7592
30/11/2008	6253.93	44068.21	13846
01/12/2008	946.07	45014.28	946.07
02/12/2008	8523.22	53537.5	9469
03/12/2008	4341.18	57878.68	13810
10/12/2008	2424.95	60303.63	16235
21/12/2008	826.94	61130.57	17062
27/12/2008	587.14	61717.71	17650
29/12/2008	21971.44	83689.15	39621

[swuehl · Accepted solution]

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]

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

[Qlik__Vinodh]

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

[Qlik__Vinodh]

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

[swuehl]

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

See attached sample.

[Qlik__Vinodh]

Thanks for reply,

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

[swuehl]

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

[Qlik__Vinodh]

Thanks a lot

[Qlik__Vinodh]

thanks a lot