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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
george456
Creator
Creator
‎2019-09-28 10:09 AM

MAT Growth formula challenges

Dear Community

 

I am need some guidance on the below formula:

 

I am using this to create a rolling MAT Value by Month and it works fine. The formula is:

=sum(if(Year2Date(PERIOD,0,if(MONTH(LatestDate)>11,1,MONTH(LatestDate)+1),LatestDate),$(vMeasure)))

My output is as follows: 

MANUFACTURERMonthYrAug 2018Sep 2018Oct 2018Nov 2018Dec 2018Jan 2019Feb 2019Mar 2019Apr 2019May 2019Jun 2019Jul 2019
Manufac 1          907,700,199         916,079,988         925,411,401         934,516,386         942,949,693         950,110,401         955,958,829         961,816,170         964,160,990         968,366,379         970,790,467         972,803,259

I need to find a way to calculate the % growth between Jul 2019 vs Jul 2018

 

Please help

516 Views
0 Likes
0 Replies