topic Rolling 15 Months Variance calculation in QlikView

Rolling 15 Months Variance calculation

Thu, 04 Feb 2016 06:13:04 GMT

Hi can any one help me to calculating rolling 15 Months Variance, means when user selects 2016 jan my application has to show last 15 months Variance with its previous year same month.

I am attaching a qvw with some sample data , can any one help me on this.

Thanks

John

Re: Rolling 15 Months Variance calculation

amit_saini — Thu, 04 Feb 2016 06:17:47 GMT

John,

Try something like below:

Sum({<YearMonth ={">=$(=Date(addmonths(Max(YearMonth), -15), 'MMM-YY')) <=$(=Date(addmonths(Max(YearMonth), -1), 'MMM-YY'))"} >} Sales)

Thanks,

Re: Rolling 15 Months Variance calculation

Anonymous — Thu, 04 Feb 2016 06:22:59 GMT

why not check this?

Calculating rolling n-period totals, averages or other aggregations

Set Analysis for certain Point in Time

Re: Rolling 15 Months Variance calculation

jagan — Thu, 04 Feb 2016 06:27:24 GMT

Hi,

check this link for this type of similar scenarios.

Set Analysis for certain Point in Time

Re: Rolling 15 Months Variance calculation

Thu, 04 Feb 2016 06:44:10 GMT

Thanks amit saini,

Your expression will work for normal sales , however I need variance of sales from its previous year same month , it is not working in my case.