Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Set Analysis - Rolling Report (5 Previous Periods & 5 Future Periods)

In the attached sample I am trying to be able to select a year and month and see in the chart the 5 periods prior to the month selected and 5 periods after the month.

Example Year: 2010 Month: December

Desired Results in Chart:

Jun-10 Jul-10 Aug-10 Sep-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar-11 Apr-11 May-11

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Hi

     Hope my example attached qv file will be helpful for your requirement

     Regards

Ashok

View solution in original post

6 Replies
Highlighted

Hi,

     Check with this expression

     Sum({<DateField={">=$(=MonthStart(Max(Date),-5))<=$(=MonthEnd(Max(Date),5))"},YearField=,MonthField=>} FieldName)

Hope it helps

Celambarasan

Highlighted
Not applicable

I applied the formula but get no data back.  Can you input the formula in the attached QVW to see if you get success?

Highlighted

Hi,

     I'm using personal edition i cann't open your file.

Celambarasan

Highlighted
Not applicable

Thanks for trying.  I could not get to work.  I must be using wrong fields.

Highlighted
Not applicable

Celambarasan,

In my chart I current have the following.  How would I modify your suggestion with these?

Dimension:  Month

Expression:  Sum ([Spend (USD)]/[Qty Received (NO DIM)])

Highlighted
Creator III
Creator III

Hi

     Hope my example attached qv file will be helpful for your requirement

     Regards

Ashok

View solution in original post