Skip to main content

Qlik

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
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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: 
nitesh2730
Contributor II
Contributor II
‎2021-03-29 07:13 AM

rolling 12 months with date dimension in qlik sense

Hi all,

I am working on app development for which, I need to show MAT calculation from quarterly data,  

nitesh2730_0-1617016155964.png

which is possible through range sum above function(attached is desired output which is correct-3rd column), but I need to do this through sum max function(SUM({<Year=, NEW_Date = {">=$(=QuarterStart(Max(NEW_Date),-3))<=$(=AddMonths(Max(NEW_Date),-0))"}>}[Market Units])). Request you to please check and let me know if it is possible.

Thanks in advance! @sunny_talwar 

547 Views
0 Likes
0 Replies