Shifting of the values to next row in another column-Qlik front end expression required

[santosh3]

Hi Qlik community,
I need your help in Qlik front end expression finalisation.
Column-A (Actual column) is existing column, Column-B (Requirement) is new column where I want to shift the cell values by one row to next cell in that column.

Actual column	Requirement
Column-A	Column-B
11	0
12	11
13	12
14	13

@sunny_talwar @Chanty4u can you help me in this case?

[Vegar · Accepted solution]

You could try something like in the image below using alt(above(column_a,1,1), 0)

[SunilChauhan]

Load ColumnA,

previous(ColumnA) as ColumnB

from Table order by ColumnA;

[santosh3]

I am looking for the front end expression not backend expression @SunilChauhan 

[santosh3]

Yes, this solution is working

[Vegar]

Glad  I could be of help.

Please mark it as an accepted solution if it solved your issue. That will help other people with a similar issue in the future  and signal to the other people in the community that no additional help is needed for this

.