topic Re: Previous Year, YoY Analysis ( Year to Year ) in QlikView

Previous Year, YoY Analysis ( Year to Year )

amithmurali — Sun, 12 Jul 2015 06:42:44 GMT

Hi guys,

i have a problem. i want to compare YOY revenue in my dashboard. but when i do the comparison, for example, if i have data till may of 2015. it is comparing with the entire revenue for 2014. i dont want like that. i want to compare till 2014 may only when i comparing 2015 may. i am sending you the table and code which i have used. please help me.

Date	Revenue
12-jan-2014	123234
3-feb-2014	234234
:	:
:	:
1-jan-2015	1212313
1-feb-2015	334341
1-mar-2015	423424
1-april-2015	3434321
1-may-2015	23432423

"=sum({<Year = {$(=max(Year))}>}(Revenue))/sum({<Year = {$(=max(Year)-1)}>}(Revenue))"

I am using Universal Calender for the tables.

Re: Previous Year, YoY Analysis ( Year to Year )

maxgro — Sun, 12 Jul 2015 06:51:28 GMT

this should help

Year-over-Year Comparisons

Re: Previous Year, YoY Analysis ( Year to Year )

ankitbisht01 — Mon, 13 Jul 2015 07:32:02 GMT

Hi Amith, There is more then one possible way, describing one over here. Logic is.(This will work on your selection of year).

1. For current Year you just need = sum(revenue)

2. Previous month revenue according to current year Dates = sum({<Year={'$(=max(Year)-1)'},Date={">=$(vPYMinDate)<=$(vPYMaxDate)"}>}Revenue).

3. You can find these variables in application.

4. here attached solution qvw on your data .PFA

Regards

Ankit