To get the accumulation of data

[#1]

Hi all,

I hav a data file lik

Date	Sales
01-01-2013	234
02-01-2013	879
03-01-2013	78890
04-01-2013	709
05-01-2013	6987
06-01-2013	70908
07-01-2013	797
08-01-2013	8798
09-01-2013	7089
10-01-2013	6890
11-01-2013	7987
12-01-2013	8709

i need in the qlikview,lik when i select a date the sum of sales amount till that date shoud display.how it can be done.

thanks in advance

[#2]

hi

try see this.

The Magic of Set Analysis – Point In Time Reporting | iQlik - Everything QlikView.

[sushil353]

Hi,

Please find attached qvw for solution.

Make sure that your environmental variable in script are in DD-MM-YYYY format.

HTH

Sushil

[tresesco]

May be like attched sample?

[er_mohit · Accepted solution]

see the attached file