Discussion board where members can get started with QlikView.
I have a table (see attached) with missing values for the months to come in 2017.i want to fill this cells with the avg growth over last 3 years.
it is some kind of forecasting.
thanks for your help.
Temp: LOAD Quarter, Month, , , , , If(Len(Trim())=0 or  = '-',Round(RangeAvg(,,),0.01),) as  FROM "https://community.qlik.com/servlet/JiveServlet/download/1280318-281476/Example%20Data.xlsx" (ooxml, embedded labels, table is Blad1); Table: CrossTable(Year, Value, 2) LOAD Quarter, Month, , , , ,  Resident Temp; Drop Table Temp;
i can't do this in load script
I calculate Vincome as variable after load.