Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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
Take a look at qlikview component project on google. Rob, a great qlikview expert, leads this project.
Your solution is there.
Taxaw, from Senegal