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