Discussion board where members can get started with QlikView.
I have a data like below
here I want output like
how can I achieve this?
You want this in a chart or script?
LOAD *, PEEK(sales)+sales AS Newcolumn; LOAD * Inline [ Name,sales aa,100 bb,200 cc,300 dd,400 ];
Thanks for the reply.
Its working fine now.
much appreciated for the video provided.
You can do the same with RangeSum()
LOAD *,RangeSum( Previous(Sales)+Sales ) as NewCol;
LOAD * Inline