Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
csh8428
Contributor II
Contributor II

How to Calculate Month over Month change by year change

I have a pretty simply data-set(attached). I want to count how many projects have start dates in a given month and compare them for each month across years. using the attached dat-set it would look like this: sample screenshot.png

I would also like to display the percentage change for each MoM inside the bars or at least as a tool-tip.

Thanks for any help!

 

-Craig

Labels (3)
1 Reply
Andrea_Bertazzo
Support
Support

I would add a Year and a Month field in the script, this would be make easier to create the table you need.
You could use these formulas to see the number of projects by year. As dimension in the chart you can use month and then

Count({$<Year={$(=Year(today())}>}Project) for the current year
Count({$<Year={$(=Year(today())-1}>}Project) for the previous year
Count({$<Year={$(=Year(today())-2}>}Project) for two years ago

I hope this helps

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂