Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
julian_ortiz
Partner - Contributor III
Partner - Contributor III

How to pass value in rows to another column

Hi, i have this data

Month
Value

201205

200
201204100
20120350
201202100

I want manipulate the data and pass to one row, like this

Month
Current
Month-1
Month-2
20120520010050
20120410050100
201203501000

The idea is have the current value and the last 4 months.

¿Any suggestions?

Thanks in advance

Julian

4 Replies
Not applicable

Something like this would not be hard.

Not applicable

I think this is what you did imply

julian_ortiz
Partner - Contributor III
Partner - Contributor III
Author

Thanks for help me Nick. Regards

julian_ortiz
Partner - Contributor III
Partner - Contributor III
Author

Thanks for help me. Regards