Populating Null Values in Month with Value Previous Month

[#1]

Hello,

I have the following chart, to display the total stock over a period of time (where the stock changes cause of mutations for each article that are calculated).

The stock value is calculated by date. So the month is a total sum of stock in that month.

Problem is, when an article does not have mutations in a certain month, stock value is 0. So in some months the current stock values are missing.

Is there a way to populate the empty values with the value of last month?

[kumarnatarajan]

Hi,

Refer This URL

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field

[#3]

Hey, the problem is, I cant really do this in the script. Since i did alot of calculations to finally got what I have now, and i want to sum them up for a month. so its not a problem in the data itself, its the used dimension