Year over Year Average growth Rate of two measures

[vidyasagar159]

Hi All,

I want to calculate the Average growth rate of all my sales amount and the budget amount from the day the product launched. 

Here is the sample data. I was able to achieve the Year of Year growth rate of each product. But I need Average growth for each product. So that I can see which product is performing better from the below plot.

Product	Launch Date	Sales Date	Sales Amount	Sales GrowthRate Year Over Year	Budge Amount	Budget GrowthRate Year Over year
Apple	2015	2015	$                 100.00		$              1,000.00
Apple	2015	2016	$                 200.00	100%	$              1,500.00	50%
Apple	2015	2017	$                 150.00	-25%	$              2,500.00	67%
Apple	2015	2018	$                 170.00	13%	$              2,600.00	4%
Apple	2015	2019	$                 210.00	24%	$              7,000.00	169%
Samsung	2014	2014	$                   80.00		$                 150.00
Samsung	2014	2015	$                 110.00	38%	$                 300.00	100%
Samsung	2014	2016	$                 150.00	36%	$                 350.00	17%
Samsung	2014	2017	$                 130.00	-13%	$                 380.00	9%
Samsung	2014	2018	$                 120.00	-8%	$                 400.00	5%
Samsung	2014	2019	$                 200.00	67%	$                 450.00	13%

Expected ResultSet:

Product	Average SALES GrowthRate of Each Product Since it Launched	Average Budget GrowthRate of Each Product Since it Launched
Apple	28%	72%
Samsung	24%	29%

Scatter Plot :

Thanks in advance!!!

-Vidya

[Taoufiq_Zarra]

attached a qvf version

[vidyasagar159]

Thanks for your response. But I really can't use the attached file. Our firm only allows us to develop Apps in the Qliksense web version. If you don't mind can you please share the script and expression.

Thanks,

-Vidya

[Taoufiq_Zarra]

just add a table with

product as dimension

and mesure1==avg([Budget GrowthRate Year Over year])

and mesure2=avg([Sales GrowthRate Year Over Year])

and for the chart the same dimension and mesures

on complement add reference line and personalise axis

[vidyasagar159]

Thank you for your response. Your solution works only when I have Growth Rate Year over Year on Load Script level. How Can you achieve avg([Budget GrowthRate Year Over year]) and avg([Sales GrowthRate Year Over Year]) without having Growth Rate Year over Year on the script level? I can able to create a growth rate only on a measure expression.

Thanks,

-Vidya