topic Re: Creating forecast data in QlikView

Creating forecast data

Mon, 03 Oct 2011 07:55:31 GMT

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?

Creating forecast data

Anonymous — Mon, 03 Oct 2011 08:04:39 GMT

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.

Re: Creating forecast data

Mon, 03 Oct 2011 08:40:04 GMT

Hi Dennis

You will do this in the load?

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

Creating forecast data

Anonymous — Mon, 03 Oct 2011 10:47:26 GMT

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.

Re: Creating forecast data

Anonymous — Mon, 03 Oct 2011 11:04:28 GMT

See Attached QV-file.

Re: Creating forecast data

Mon, 03 Oct 2011 11:39:06 GMT

This is great Dennis – I will try it right away

TY for you help

Creating forecast data

Mon, 03 Oct 2011 12:08:30 GMT

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.

Re: Creating forecast data

Anonymous — Mon, 03 Oct 2011 12:43:16 GMT

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.