Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

Hi

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

     Regards

Ashok

View solution in original post

6 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Check with this expression

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

Hope it helps

Celambarasan

Not applicable
Author

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

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

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

Celambarasan

Not applicable
Author

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

Not applicable
Author

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)])

Anonymous
Not applicable
Author

Hi

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

     Regards

Ashok