How to create date wise accumulation in qlikview using the as of table

[ananyaghosh]

Hi,

I need to get sum(sales) date wise means accumulation of dates using as of table concept.

Any idea how to do that?

[Anil_Babu_Samineni]

May be this?

Rangesum(Below(Aggr(Sum(sales),DateField),0),Above(sales,1,Rowno()))

Or

Aggr(Rangesum(Below(Sum(sales),0),Above(sales,1,1000)), DateField)

[ananyaghosh]

Hi

I need the mtd calculation in my as of table script and i need to implement MTD for my date collumn. So it should show the accumulated sum of sales from start date of month to that specific date.

So please give me a script that will calculate roolling period of date.

[Anil_Babu_Samineni]

So please give me a script that will calculate roolling period of date.

You want to do this in Script?