Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You could try something like in the image below using alt(above(column_a,1,1), 0)
You could try something like in the image below using alt(above(column_a,1,1), 0)
Load ColumnA,
previous(ColumnA) as ColumnB
from Table order by ColumnA;
I am looking for the front end expression not backend expression @SunilChauhan
Yes, this solution is working
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
.