topic Growth Calculation in QlikView

Growth Calculation

upaliwije — Thu, 10 Aug 2017 10:16:29 GMT

Hi Friends

I want to calculate growth % in my pivot table. My Pivot Table looks like below

Here the Month and Year are Dimensions. My expression for calculation is sum(PREMIUM). I want to calculate yearly growth and output report should look like as shown below. Pls help me to to write an expression for growth % calculation

Re: Growth Calculation

sunny_talwar — Thu, 10 Aug 2017 11:16:47 GMT

Try this

(Sum(PREMIUM)/Before(Sum({<YEAR>}PREMIUM)) - 1) * Avg(1)

Re: Growth Calculation

upaliwije — Fri, 11 Aug 2017 03:18:54 GMT

Thanks Sunny

It works. I would like know what does this part works and why it is necessary ? I can not understand it * Avg(1)

Re: Growth Calculation

sunny_talwar — Fri, 11 Aug 2017 11:15:18 GMT

Just to make sure that you still see a percentage when you make selection in Year field I had to ignore selection in year field.... once I do that, I might see all the years and to get rid of the non selected years, I multiply it with Avg(1)

Re: Growth Calculation

upaliwije — Sat, 12 Aug 2017 10:47:45 GMT

Thnaks

Re: Growth Calculation

Dolly123 — Fri, 11 Mar 2022 10:14:58 GMT

not working