Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ishanbansal1204
Contributor III
Contributor III

Week on week Calculation

Hi Experts,

I have a situation where i have to calculate WOW

It is fine if the week falls in the same year but lets say week is 1 and last week will be max of week of last year.

Not getting the solution for the same. Can you please suggest

(Sum({<WEEK = {$(=Max({<Year={$(=MAX(Year))}>} WEEK))}, Year = {$(=MAX(Year))}>} M_COUNT_WEEK) -

Sum({<WEEK = {$(=Max({<Year={$(=MAX(Year))}>} WEEK - 1))}, Year = {$(=MAX(Year))}>} M_COUNT_WEEK)) /

Sum({<WEEK = {$(=Max({<Year={$(=MAX(Year))}>} WEEK - 1))}, Year = {$(=MAX(Year))}>} M_COUNT_WEEK)

3 Replies
sunny_talwar

I think that's why you should either use a field which includes week and year or just use date field.

ishanbansal1204
Contributor III
Contributor III
Author

Hi Sunny,

But the thing here is that i have a parameter for week and year

sunny_talwar

But they are two different fields, I would work with a single WEEK_YEAR field to get this kind of requirement which spans multiple years