topic Re: Forward Values along periods with null value in QlikView

Forward Values along periods with null value

orital81 — Mon, 13 May 2013 09:17:28 GMT

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:

Here is how I would like it to be:

..... Continue till 2014-05

Attached the QVW file.

Thanks for your help!

Re: Forward Values along periods with null value

orital81 — Mon, 13 May 2013 09:33:45 GMT

I would appreciate any suggestion

Thanks.

Re: Forward Values along periods with null value

sushil353 — Mon, 13 May 2013 09:45:30 GMT

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.

Re: Forward Values along periods with null value

orital81 — Mon, 13 May 2013 09:53:09 GMT

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.

Re: Forward Values along periods with null value

sushil353 — Mon, 13 May 2013 09:57:34 GMT

i think you should go for master calender.

Re: Forward Values along periods with null value

orital81 — Mon, 13 May 2013 10:54:33 GMT

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

Re: Forward Values along periods with null value

Gysbert_Wassenaar — Mon, 13 May 2013 12:23:48 GMT

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

Re: Forward Values along periods with null value

orital81 — Wed, 15 May 2013 09:49:11 GMT

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