How to find change in the price across ratio?

[priyalvp24]

Dear All,

I want to find the Change in the Price(Delta Price) Across the ratio in qliksense.

I want to show in line chart as Ratio on X-axis & Change in the Price(Delta Price) on Y-axis.

Below is my data.

Please Help.

Year	Ratio	Price
2002	1.29	25.61
2003	1.32	22
2004	1.50	21
2005	1.39	33
2006	1.28	38
2007	1.42	56
2008	1.38	50.02
2009	1.35	56.66
2010	1.31	62.13
2011	1.18	73.33
2012	1.30	88.82
2013	1.23	63.66
2014	1.02	66.86
2015	0.75	77.05
2016	0.59	123.33
2017	0.63	187.69
2018	0.38	172.74

Regards,

Priyal.

[Anil_Babu_Samineni]

Any example you have?

[priyalvp24]

Hi Anil,

Thanks for your reply.

Example is below.

For year 2002,Rate 25.61 & year 2003,Rate 22

So change in price for year 2003 will be 25.31-22 i.e. 3.61

Regards,

Priyal.

[Anil_Babu_Samineni]

Check if that helps?

Above(Sum(Price))-Sum(Price)

[priyalvp24]

Thanks a lot...

[Anil_Babu_Samineni]

Glad we were able to find, Can you please close this thread by flag "Correct answer"

[consultant_bi]

yep please close this discussion by mentionning loveisfail‌ answer as correct