6 Replies Latest reply: Oct 30, 2018 11:45 AM by Fathi Ali

# How to find change in the price across ratio?

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.

 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.

• ###### Re: How to find change in the price across ratio?

Any example you have?

• ###### Re: How to find change in the price across ratio?

Hi Anil,

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.

• ###### Re: How to find change in the price across ratio?

Check if that helps?

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

• ###### Re: How to find change in the price across ratio?

Thanks a lot...