topic YOY Calculation.. in QlikView

YOY Calculation..

Tue, 21 Aug 2012 09:12:50 GMT

Hello Everyone,

am new bee to Qlik view ,here i need your help in calculating QOQ and YOY...

scenario is like this...i have a multibox where i have quarters dropdown....based on the selection of particular quarte, we should calculate the QOQ.......

Pleae let me know if i need to attach the solution..

Thanks & Regards,

Venkat T

Re: YOY Calculation..

Tue, 21 Aug 2012 10:57:32 GMT

I am sorry to post this as i could see many posts against YOY....here my problem is the quarter(Q1'09,Q1'10...) and Year(FY09,FY10,FY11...) fomats..

Please need help...

Thanks & Regards,

Venkat T

Re: YOY Calculation..

sebastiandperei — Tue, 21 Aug 2012 11:16:13 GMT

Sorry, but I can't understand the question... could you send a reduced copy of your qvw?

Re: YOY Calculation..

Tue, 21 Aug 2012 13:09:34 GMT

Hi Sebastian,

Thanks for your reply..Please find the qvw file attached.

Thanks & Regards,

Venkat T

Re: YOY Calculation..

SunilChauhan — Tue, 21 Aug 2012 14:12:22 GMT

calculate like below

for current year

sum({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} amount)

for Previous year

sum({$<Year = {$(=max(Year - 1))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} amount)

hope this helps

Re: YOY Calculation..

Wed, 22 Aug 2012 07:41:12 GMT

Hi Sunil,

Thankyou so much for your Answe, but am sorry to say that didnt help me much.

Please need more suggestions,

Thanks,

Venkat T

Re: YOY Calculation..

sebastiandperei — Wed, 22 Aug 2012 12:21:24 GMT

Sorry, but my english is not good... Could you explain a little better the request?