Issue on 12 months rolling....

chinnu123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I am facing an issue on 12 months rolling data in Barchart

My scenario is

for example this is June 2016 so then the data must be shown from July 2015 to June 2016

July 2016 so then the data must be shown from august 2015 to July 2016

The data is related to Incidents and the fields are Submit month and Incidents ''

please can any one help on this..

Thanks,

Bhargav.

Re: Issue on 12 months rolling....

vikramv — Wed, 29 Jun 2016 21:04:42 GMT

Try this in your expression...

Sum($<Datefield = {">=$(=Date(AddMonths(Date(Today(),'YYYY-MM'), -11), 'YYYY-MM'))<=$(=Date(AddMonths(Date(Today(),'YYYY-MM'), 1), 'YYYY-MM'))"}>} Sales)

topic Issue on 12 months rolling.... in QlikView

Issue on 12 months rolling....

Re: Issue on 12 months rolling....