topic Re: Forecast in QlikView

Forecast

tracycrown — Sat, 16 Nov 2024 04:57:25 GMT

Dear all

I have problem in writing script to forecast the sales volume, please help urgently.

The correct answer is computed and shown in the worksheet.

Thank you

Tracy

jaibau1993 — Mon, 17 Dec 2018 08:36:25 GMT

Hi!

Please, try the following expresion:

if(RowNo()=1,
//if first row then the value of thge first column
	Column(1)
,
//else, formula provided
	Above(Column(1))*0.3+Above(Column(2))*0.7
)

or, if you prefer, find the attached QV file.

Bests,

Jaime.

tracycrown — Tue, 18 Dec 2018 09:12:34 GMT

Dear Jaibau1993

The answer is correct, you are very clever.

Many Thanks

Tracy