Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
selvakumara
Not applicable

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
Not applicable

Re: Rolling 12 Months Data

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
Not applicable

Re: Rolling 12 Months Data

Let TimeField='YOUR DATE FIELD HERE'; ?


Need some example