Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use combo charts and use dual axis
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?