Hi,
I was trying to create a sales growth line chart that shows the growth percent comparing the sales data to previous month. Eg for jan 2020 the growth is wrt jan 2019 and etc. I wanted to show this trend line for all the data present in Qlik. Earlier I was thinking of using = Sum([Gross Sales])/Above(Sum([Gross Sales]))-1 but the above trend line shows growth compared to the previous month. But as mentioned the line should show compared to the previous year.
Also
(sum({< [Date.autoCalendar.Year]={'$(=max([Data.Year]))'}>} [Gross Sales])
/sum({< [Date.autoCalendar.Year]={'$(=max([Data.Year])-1)'}>} [Gross Sales])) -1
this formula wouldn't work as only for the recent month and year the trend line will be shown.
Thanks