Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

orital81
Contributor III

Forward Values along periods with null value

Hi All

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:

Current.JPG

Here is how I would like it to be:

Wanted.JPG ..... Continue till 2014-05

Attached the QVW file.

Thanks for your help!

1 Solution

Accepted Solutions

Re: Forward Values along periods with null value

I think you need to create the 'missing' values in the script. This blog post may help you do that.


talk is cheap, supply exceeds demand
7 Replies
orital81
Contributor III

Re: Forward Values along periods with null value

I would appreciate any suggestion

Thanks.

sushil353
Honored Contributor II

Re: Forward Values along periods with null value

Hi Ori,

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.

orital81
Contributor III

Re: Forward Values along periods with null value

Hi Sushil

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.

sushil353
Honored Contributor II

Re: Forward Values along periods with null value

i think you should go for master calender.

orital81
Contributor III

Re: Forward Values along periods with null value

There is a master calendar. It's joined to the table.

Re: Forward Values along periods with null value

I think you need to create the 'missing' values in the script. This blog post may help you do that.


talk is cheap, supply exceeds demand
orital81
Contributor III

Re: Forward Values along periods with null value

Thanks Gysbert, that's exactly what I was looking for.

Community Browser