topic Re: Percentage Difference Calculation in multiple line chart in App Development

Percentage Difference Calculation in multiple line chart

deepakgs21 — Fri, 17 May 2024 12:50:11 GMT

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

Re: Percentage Difference Calculation in multiple line chart

SunilChauhan — Mon, 20 May 2024 13:07:45 GMT

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/58078#:~:text=You%20can%20do%20this%20in,dual%20axis%20as%20you%20request.

Re: Percentage Difference Calculation in multiple line chart

deepakgs21 — Wed, 29 May 2024 18:40:45 GMT

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?