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

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

Fri, 17 Feb 2012 13:09:16 GMT

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

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

CELAMBARASAN — Fri, 17 Feb 2012 13:17:15 GMT

Hi,

Check with this expression

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

Hope it helps

Celambarasan

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

Fri, 17 Feb 2012 13:19:32 GMT

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

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

CELAMBARASAN — Fri, 17 Feb 2012 13:20:52 GMT

Hi,

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

Celambarasan

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

Fri, 17 Feb 2012 13:22:58 GMT

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

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

Fri, 17 Feb 2012 13:31:16 GMT

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

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

Anonymous — Fri, 17 Feb 2012 13:51:52 GMT

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

Regards

Ashok