Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

chinnu123
Contributor

Issue on 12 months rolling....

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.

1 Reply
vikky
Contributor III

Re: Issue on 12 months rolling....

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)