Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator 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
sunny_talwar

Try this

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

View solution in original post

5 Replies
sunny_talwar

Try this

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

upaliwije
Creator II
Creator II
Author

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)

sunny_talwar

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
Creator II
Creator II
Author

Thnaks

Dolly123
Creator II
Creator II

not working