Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlik community,
I've the annual Sales in a table below.
I want to calculate the growth in sales year over year (YOY) in Qlikview. So: (Current year - Last year) / Last year.
Is there somebody who can help me?
Thanks!!
Use above function. something like
(Sum(LineSalesAmount) - above(Sum(LineSalesAmount)))/above(Sum(LineSalesAmount))
Hi,
Try like this.
Data:
LOAD * INLINE [
Product,Year,Sales
P1,2011,12527
P1,2012,31179
P1,2013,43069
P1,2014,23091
P2,2011,12527
P2,2012,31189
P2,2013,43069
P2,2014,23091
P3,2011,12526
P3,2012,31157
P3,2013,43012
P3,2014,23065
];
Hi ewoutgaan
Did you test?