How Create Prior Year Column

[ksomosera10]

Hi,

Im new at Qlik Sense and I need to create a column expression to create a Prior Year column.

You can check on my example on what I needed to accomplish.

Year   || Sales   ||  PriorYearSales

2013  ||   420    ||     0

2014  ||   250    ||     420

2015  ||   143    ||     250

2016  ||   156    ||     143

2017  ||    320   ||     320

I can create expressions to sum these values but I can't put the values to a different or prior year.

I hope someone could help me out here. Thanks!

[gowtham_patnaik]

can u upload some sample qvw. so that i can figure it out.