topic Re: YOY analysis in QlikView

YOY analysis

raju_salmon — Tue, 04 Jul 2017 14:05:16 GMT

Hi Experts,

I have a requirement where i should compare past 12 months (based on today day ex: Today Jul4th 2017 so Jul 2016-Jun 2017 - 12 months) with past to past 12 months (means Jul 2015-Jun2016) and it should dynamic.

Can any tell me how can i consider this using YearToDate or InYearToDate function? Month will be my dimension.

Thanks,

Raju.

Re: YOY analysis

MK_QSL — Tue, 04 Jul 2017 14:10:28 GMT

You need YearMonth or MonthYear as Dimension

Expression

RangeSum(Above(SUM({<MonthYear>}Sales),0,12)) * Avg(1)

Make sure that you have sort order Ascending on YearMonth or MonthYear

Re: YOY analysis

raju_salmon — Wed, 05 Jul 2017 01:21:25 GMT

Hi,

Dimension is only month. Charts shows 12 months (12 bars) each bar compare data between two months (this year vs last year)

Re: YOY analysis

sunny_talwar — Wed, 05 Jul 2017 12:19:36 GMT

May be this

This Year

Sum({<Year = {"$(=Max(Year))"}>}Sales)

Last Year

Sum({<Year = {"$(=Max(Year)-1)"}>}Sales)