Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
upaliwije
Contributor II

Growth Calculation

Hi Friends

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

Screenshot_1.png

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

Screenshot_2.png

1 Solution

Accepted Solutions

Re: Growth Calculation

Try this

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

4 Replies

Re: Growth Calculation

Try this

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

upaliwije
Contributor II

Re: Growth Calculation

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

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)

upaliwije
Contributor II

Re: Growth Calculation

Thnaks