YOY Calculation..

[#1]

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

[#2]

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

[sebastiandperei]

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

[#4]

Hi Sebastian,

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

Thanks & Regards,

Venkat T

[SunilChauhan]

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

[#6]

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

[sebastiandperei]

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