Stock value Daily

[#1]

Hi All,

i have a table with these columns Area,Country,Product,Date,Quantity

it's  a transactions table i want to evaluate the stock every day and for the missing dates in the table

how to do that?

Thanks.

[MK_QSL]

Instead of SUM(CumulativeStock) us =CumulativeStock in expression.

[#3]

Oh, i didn't notice this reply. sorry for that.

i'm trying in it current now.

Thanks  QlikPahadi07!

[qlikpahadi07]

It still didn't meet your requirement ??

[#5]

No, as when i'm trying to display the product and date and qty

the values of the 2nd product y are not correct

the values should be 

Product	Date	Qty
X	1/1/2010	100
X	3/1/2010	120
X	5/1/2010	220
X	6/1/2010	250
X	9/1/2010	260
Y	2/1/2010	15
Y	3/1/2010	215
Y	7/1/2010	235
Y	8/1/2010	385

Attached is the same file after trying to add what i'm talking about