Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ronald
Contributor III
Contributor III

Growth rate Line Chart of Date vs previous Date

I would like to graph the monthly growth, this should be a comparison of the month vs the same month of the previous year.

growth line chart.PNG

Appreciate your help

Labels (1)
3 Replies
sasikanth
Master
Master

HI, 

Try below

Dimension : MONTH

Exp for MoM growth rate;

NUM( (sum({<YEAR={$(=max(YEAR))}>}Salary) -sum({<YEAR={$(=max(YEAR)-1)}>}Salary) )/

sum({<YEAR={$(=max(YEAR))}>}Salary) ,'#,##0.00%')

 

MoMgrowth.png

Ronald
Contributor III
Contributor III
Author

Thanks, but don't work

'NUM( (sum({<Fecha={"$(=max(Fecha))"}>}Total) /sum({<Fecha={"$(=max(Fecha)-1)"}>}Total) ),'#,##0.00%')'

sasikanth
Master
Master

Please check Fecha format it should be YEAR filed, and what is Total ?? is it a measure?