Week on Week

[NM5]

Hi,

I am new to QlikSense therefore I need your help in creating Week on Week measure for my analysis. I have attached the sample dataset herewith for your reference. 

I am trying to calculate WoW for the calculated column ie Num/Deno. I am getting some incorrect values for week 30 and 31 and zeros for Wk 28 and 29. Even when I'm trying to use last week its giving the same week's values. 

@johnw @devarasu07 @shree909 @vinieme12  Please help !!

[Lisa_P]

Use the before function to compare to previous week..

Num/Deno - before(Num/Deno)

[NM5]

Thanks Lisa_P for the prompt response.

This measure is working for the immediate weeks. What if we want to calculate the week on week difference based on filter selection. Suppose we want to calculate the difference between wk30 and wk 28 as per the user selection in the week range filter.

Thanks

[Lisa_P]

There is an offset available within this function, so you could create a variable to choose how many weeks back and use the Variable Input extension object to let them select the variable value.

Num/Deno - before(Num/Deno, $(vOffset))