topic Prior Week ,Prior month,Prior 3 Month,Prior 12 Month in QlikView

Prior Week ,Prior month,Prior 3 Month,Prior 12 Month

Thu, 31 Jul 2014 11:20:31 GMT

Hi,

I was trying to get the data for previous week and previous months ,below are the conditions what I want to achieve.

1)Prior Wk--Always should be sum of previous week data(example:present week is 31st so we need to do sum of 30th week data)
2)Prior Month-Always should be sum of 4 previous weeks data (means sum of 27th week to 30th data)
3)Prior 3 Month-Always should be sum of 12 previous weeks data (means sum of 19th week to 30th data)
4)Prior 12 Month-Always should be sum of previous 12 months data(means sum of last year from 34th week to present year 30th week data)

based on FISCAL_YEAR_WEEK_NUM field we need to get the Week Numbers.

thanks in advance

Re: Prior Week ,Prior month,Prior 3 Month,Prior 12 Month

whiteline — Thu, 31 Jul 2014 11:33:31 GMT

Hi.

You can use set analysis for periods.

Calculating rolling n-period totals, averages or other aggregations

And WeekNum function to calculate # of week.

Re: Prior Week ,Prior month,Prior 3 Month,Prior 12 Month

Thu, 31 Jul 2014 11:56:10 GMT

Looks I have issue in data model..Can any one suggest me where went wrong.

Thanks

SwathiRaj