Creating forecast data

[#1]

Hi

Im trying to make a forecast chart but need a little help to get it to work.

What Im trying to do is:

Month     Known Price    "Forecast price

               (the last know price are used)"

Jan     10     

Feb     11     

Mar     10     

Apr      9     

Maj     11     

Jun     10     

Jul               10

Aug               10

Sep               10

Okt               10

Nov               10

Dec               10

But I don't seem to have any luck finding the right way to make my chart show "created values"

Can anyone help?

[Anonymous]

Hi There

You could use the Peek() funtion for this. Like:

LOAD Month,

    IF( ISNULL(Price) ,Peek(Price), Price) as Price

Hope this works for you.

[#3]

Hi Dennis

You will do this in the load?

Sorry to sound darf but what exactly is this script doing?

[Anonymous]

Yes in the loading script.

This Peek() function returns the value of the previous record.

So:

IF( ISNULL(Price)             Where the field Price has no value

,                                                  then

Peek(Price)                      return the previous value

,                                     else

Price)                                        the  value of  Price

as Price

In your example July is empty so it gets the value from June.

August will get the value of July (which now is the same as June) etc.

[Anonymous]

See Attached QV-file.

[#6]

This is great Dennis – I will try it right away

TY for you help

[#7]

Hi All,

             Thanks for your kind replies, i have idea about to get it script(Forgotten to menion, i needed it in Pivot table).

How can i achive the same thing in pivot table.

Regards,

Ravi.

[Anonymous]

If you use it like this, it autogenerates the values for the field (where the value is empty)

So this way you should be able to use it in any table or charts.