Discussion board where members can get started with QlikView.
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?
Use above function. something like
(Sum(LineSalesAmount) - above(Sum(LineSalesAmount)))/above(Sum(LineSalesAmount))
Try like this.
LOAD * INLINE [
Did you test?