QlikSense Input Variable - So many weeks back

[andre_avenant]

Hi All

Just a question, how would i go about creating a variable for a certain amount of weeks back. So What i want to create a a button or input area where a user can enter a value, lets say 5, and then it works out the current week number back so many weeks.

Thanks in advance

Andre (Newbie)

[Anil_Babu_Samineni · Accepted solution]

Create expression like, Input_Variable is your input data by user.

Sum({<Week = {">=$(=Max(Week-$(Input_Variable)))<=$(=Max(Week))"}>} Measure)