
Re: How to calculate growth rate in Qlik Sense?
Sunny Talwar May 9, 2018 7:35 AM (in response to yashu liao)Something like this
(Sum(Measure)/After(Sum({<Year>}Measure))  1) * Avg(1)

Re: How to calculate growth rate in Qlik Sense?
yashu liao May 10, 2018 9:24 PM (in response to Sunny Talwar )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!

Re: How to calculate growth rate in Qlik Sense?
Sunny Talwar May 10, 2018 10:23 AM (in response to yashu liao)Awesome, please close the thread in that case
Best,
Sunny



Re: How to calculate growth rate in Qlik Sense?
Hitesh Patil May 9, 2018 8:18 AM (in response to yashu liao)Hi Yashu,
If I got your requirement correctly then you are trying to calculate YoY  Year Over Year growth from the table
For Example: 201718: 10782
201617: 10478
then Growth Rate for Year 201718 will be (10782/10478)1 i.e. 2.90%.
For above problem statement, one solution which can be proposed is:
1. First Order your table on Year in Ascending Order while loading.
Example: Your table after loading script should be in below order:
2. Add one more Field while loading your table in Load Editor using Previous() Function, as shown below.
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

Re: How to calculate growth rate in Qlik Sense?
yashu liao May 9, 2018 11:55 PM (in response to Hitesh Patil )Hi Hitesh,
I really appreciate your help!
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!

Re: How to calculate growth rate in Qlik Sense?
Hitesh Patil May 11, 2018 12:55 AM (in response to yashu liao)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



Re: How to calculate growth rate in Qlik Sense?
Jahanzeb Hashmi May 10, 2018 3:20 PM (in response to yashu liao)Please close it