Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a forecast for Inventory values
But, the values appear in the source table only
if there was any expected transaction.
I would like to to the following:
In case a month has no value, forward the values from last period where there was a value (Total Forecast is 1 year)
For example, here is my current table:
Here is how I would like it to be:
..... Continue till 2014-05
Attached the QVW file.
Thanks for your help!
Go to Solution.
I think you need to create the 'missing' values in the script. This blog post may help you do that.
I would appreciate any suggestion
If you check your dataset .. then you can analize that the 2013-06 month is not associated with the current selections. if it is associated with the dataset and the value is null then we can assign it the previous month value.
This is one of the issues I would like to consult.
How can I assosiate the calendar to periods where there are no records.
I know that interval match can be used for this, but I prefer to use a different method.
i think you should go for master calender.
There is a master calendar. It's joined to the table.
Thanks Gysbert, that's exactly what I was looking for.