Discussion Board for collaboration on QlikView Scripting.
I have the following table (attached).
I need to develop a column (Backlog) which will be aggregated sum of the column (Old_Backlog) and looks like:
Backlog of 03/05/2016 is Old_Backlog of 01/05/2016 + Old_Backlog of 02/05/2016+Old_Backlog of 03/05/2016.
Backlog of 04/05/2016 is Old_Backlog of 01/05/2016 + Old_Backlog of 02/05/2016+Old_Backlog of 03/05/2016 + Old_Backlog of 04/05/2016.
For this purpose i used function Aggr in the following way:
but it does not work and shows data of Old_Backlog.
Go to Solution.
View solution in original post
or in script like below
if(Date<>previous(Date), Rangesum(Peek('Old_Backlog'),Backlog),Backlog) as Old_Backlog
order by Date asc;
drop table Data;
actually I made a mistake in my question.
My table should look like:
i.e. to shift it one row above.
actually this solution worked for me!
Thanks a lot!!!