Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
selvakumara
Creator
Creator

Rolling 12 Months Data

Hi Guys,

I have a requirement like below.

If i selected a Year = 2017 , it will display 12 months data

Dimension = YearMonth (Jul-16 to Jun-17 )

Expression :  RangeSum(Above(Count({$<[Group] = {'****************************'}>} DISTINCT record ), 0, 12))

Total for the year = 190. its correct for Jun-17.

But rest of the months are not correct.

I want the solutions like ,

For Aug16-  I wants the data from (aug15-jul@16) like for each months . As of of it was pulling like (jun16-aug16)

Thanks in advance.

1.PNG

2 Replies
devarasu07
Master II
Master II

Hi,

Try to create rolling 12 month flag in back end master calendar script then u can easily use anywhere at front end

  If( $(TimeField) > addmonths($(CurrentDate),-12) and $(TimeField) <= Today(),1) as _R12

Re: Rolling 12 months flag in master calendar script?

selvakumara
Creator
Creator
Author

Let TimeField='YOUR DATE FIELD HERE'; ?


Need some example