Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
can u upload some sample qvw. so that i can figure it out.