Help me to calculate the % growth in Sales

[Anonymous]

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

[dplr-rn]

Use above function. something like

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

[qlikviewwizard]

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

];

[qlikviewwizard]

Hi ewoutgaan‌

Did you test?