Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Help me to calculate the % growth in Sales

Dear Qlik community,

I've the annual Sales in a table below.

Annual Sales.png

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!!

3 Replies
Highlighted
Partner
Partner

Re: Help me to calculate the % growth in Sales

Use above function. something like

(Sum(LineSalesAmount) - above(Sum(LineSalesAmount)))/above(Sum(LineSalesAmount))

Highlighted
Master II
Master II

Re: Help me to calculate the % growth in Sales

Hi,

Try like this.

Capture.PNG

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

];

1.PNG

2.PNG

3.PNG

4.PNG

Highlighted
Master II
Master II

Re: Help me to calculate the % growth in Sales

Hi ewoutgaan

Did you test?