HELP NEEDED IN YOY CALCULATION

[Anonymous]

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

can you please help with expression

Thanks

have a good day

[Anonymous]

@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

[#3]

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

Your solution is there.

Taxaw, from Senegal