# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for
Did you mean:
Contributor II

## How to calculate growth rate in Qlik Sense?

I have a pivot table in Qlik Sense as follow:

Anybody knows how to calculate the growth rate by year base on this table?

1 Solution

Accepted Solutions
Contributor II
Author

Hi Sunny,

Thanks a lot!

I change the function After() to before().

Using (Sum(Measure)/Before(Sum({<Year>}Measure)) - 1) * Avg(1) in expression.

It worked!

7 Replies
MVP

Something like this

(Sum(Measure)/After(Sum({<Year>}Measure)) - 1) * Avg(1)

Partner

Hi Yashu,

If I got your requirement correctly then you are trying to calculate YoY - Year Over Year growth from the table

For Example: 2017-18: 10782

2016-17: 10478

then Growth Rate for Year 2017-18 will be (10782/10478)-1 i.e. 2.90%.

For above problem statement, one solution which can be proposed is:

This field will carry your previous year Total concurrently with you current year field.

3. Basis above fields,

Growth Rate Measure will be: =Sum(Sales)/Sum(LYSales)-1

4. Output Table:

Please check if this works for you.

Regards,

Hitesh

Contributor II
Author

Hi Sunny,

Thanks a lot!

I change the function After() to before().

Using (Sum(Measure)/Before(Sum({<Year>}Measure)) - 1) * Avg(1) in expression.

It worked!

Contributor II
Author

Hi Hitesh,

The data not just include this two columns, and 'Sales' need to be summed up in order to get the total of sales. How should I define the Previous() in this case?

eg. Table include Year, Country, Category, Sales four columns.

Thanks again!

MVP

Best,

Sunny

Specialist

Partner

hi yashu,

Previous() will work for calculating growth when you have Year dimension only, so that you can bring value of previous row value concurrently with your current row value.

In case of multiple dimensions, After() will be the solution.

Thanks,

Hitesh

Tags
Community Browser