Discussion board where members can get started with QlikView.
I have date and cost column. all i need is just one more field which consists of total cost for current day + last two days in load script.
Please find the attached screenshot below.
Please let me know in case of any clarifications.
Use this bro
F:load Date, Cost, rangesum(Cost,Peek(Cost) ,Peek(Cost,-2)) as Total
Well you've 3 answer using Peek(), just check one of then and mark the right answer pls
thanks for your continuous suggestion. finally i got that..
suppose if we want to add n date (eg- last 8 dates) means, how can we achieve that simply?