Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
NM5
Contributor
Contributor

Week on Week

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. 

NM5_0-1659941193325.png

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 !!

Labels (3)
3 Replies
Lisa_P
Employee
Employee

Use the before function to compare to previous week..

Num/Deno - before(Num/Deno)

NM5
Contributor
Contributor
Author

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
Employee
Employee

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))