Discussion Board for collaboration on QlikView Scripting.
Go to Solution.
LOAD * INLINE [
ID, NumOfMonths, Value
AAA1, 13, 260
AAA2, 15, 275
load *, IterNo() as CurrentMonth, Value/iterno() as CurrentValue Resident Temp while NumOfMonths > IterNo() -1;
drop table Temp;
Excellent solution, very quick to run through as well - many thanks.
You may have to replace Value/iterno() by Value/NumOfMonths to get a fixed monthly value throughout a single year.