Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Sales growth line chart



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.



(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.


Labels (2)
0 Replies