11 Replies Latest reply: Jun 12, 2012 6:08 AM by seydou coly

# HELP NEEDED IN YOY CALCULATION

Hi qlikgurus,

i need to calculate yoy calculation so logic is current year week-previous year week/previous year week

so i 'm have week sequence num  field for 2yrs like 1(firstweek) to 104(last week)

so i'm using expression like sum({1<WEEK_SEQUENCE_NUM={\$(=ONly(WEEK_SEQUENCE_NUM)-52)}>}UNITS)

I'm using  dimensions as month and name of the week and all the values are 0

i'm doing this in pivot table

Thanks

have a good day

• ###### HELP NEEDED IN YOY CALCULATION

any suggestions plz

• ###### HELP NEEDED IN YOY CALCULATION

Hi,

Use the Logic in this application .....  http://community.qlik.com/qlikviews/1062

• ###### HELP NEEDED IN YOY CALCULATION

THANKS ganesh but doesn't helped much

• ###### HELP NEEDED IN YOY CALCULATION

any more suggestion plz

• ###### HELP NEEDED IN YOY CALCULATION

Hi,

I think you need to convert your week sequence into 2 columns of data during data load, something like below:

WeekNum, Year

1, Year1

2, Year1

....

52, Year1

1,Year2

2,Year2

...

And then use set analysis with Year=Year1 and Year=Year2.

If you can provide an example data set or qlikview file, I can try to help.

Best regards,

http://quickdevtips.blogspot.com/

• ###### Re: HELP NEEDED IN YOY CALCULATION

thanks Bilge AYDIN for your replay

can you pleae find the attached appilcation and make this work i'm new  to qlikveiw

• ###### Re: HELP NEEDED IN YOY CALCULATION

Hi Srikanth,

could you able to get this . even i have the same requirement

Thanks

Raj

• ###### Re: HELP NEEDED IN YOY CALCULATION

Hi,

Pls have a look at the attached file and let me know if is OK or if you have any questions.

Regards,

http://quickdevtips.blogspot.com/

• ###### Re: HELP NEEDED IN YOY CALCULATION

thanks Bilge AYDIN for the work around but my requirement need to have adweek as second dimension

in other words if user select week sequence no . is 98 then it previous week is 98-52=46

so value should be like

sales of week 98- sales of week 46 / sales of week 46

but your workaround doesn't works like that

• ###### Re: HELP NEEDED IN YOY CALCULATION

@raj

i couldn't able to get it work ..once i found the logic i will defintely share with you

and find the attached workaround by Bilge AYDIN may be it might help you

• ###### Re: HELP NEEDED IN YOY CALCULATION

Take a look at qlikview component project on google. Rob, a great qlikview expert, leads this project.