Use of above function for creaating new column

[Rsaiq]

Hi All,

I need to create a new column by taking existing column values in qliksense ,explaining below

Take 1st value of a existing column and paste in second row in new column,and take 2nd row value from existing column and paste it in 3rd row in new column,and so on (refer screenshot below)

I used formula as Above(sum(Cumulative)) for achieving above but its not working correctly

Please help on this,attaching excel file here

Thanks

[Rsaiq · Accepted solution]

Hi,

Achived above output by using peek function as below

peek(Cumulative ) as New Column in the script