Percentage Difference Calculation in multiple line chart

[deepakgs21]

Hi Team,

I have scenario where I have plotted Line chart using X Axis - Year, Y Axis Metric - Spend and I used one more dimension to split the spend by multiple lines. This is a native Qlik line chart.

Now I need some help to get Percentage difference in each line(delta between current data point to previous data point) belong to each year.

I tried using Sum(Spend)-Above(Sum(Spend),1) / Above(Sum(Spend),1) . This is working fine when there is only one line but not working when there are multiple line.

How do I calculate the % difference. Need help.

Best,

Deepak

[SunilChauhan]

Use combo charts and use dual axis 

https://community.qlik.com/t5/New-to-Qlik-Analytics/create-dual-axis-line-chart-in-qlik-sense/td-p/5... 

[deepakgs21]

Hi Sunil, I don't want to go with any other chart, instead I need to calculate the percentage difference for each line. Is it possible or not?