Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?