Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Populating Null Values in Month with Value Previous Month

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?

2 Replies
kumarnatarajan
Valued Contributor

Re: Populating Null Values in Month with Value Previous Month

Not applicable

Re: Populating Null Values in Month with Value Previous Month

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

Community Browser