Filter data weekly

[#1]

Hi Friends,

Attached is qvw that I created. I like to filter data weekly. Just have a look in my qvw and suggest me a better approach.

Thanks

Arindam Roy

[senpradip007]

Instead of using so many charts and variable, why do you not choose conditional expression fecility Qlik Tech has already given in

QV 11.

[juleshartley]

I would probably create a calendar table linked to the Fact table. The calendar table would join on the start date and would then have a 'week number' field counting back from the latest date.

then set a variable to the date of the selected week ie. vRepDate = min(StartDate)

I would then use set analysis in the table to filter the expression where StartDate >=vRepDate

[#4]

Could you please give me an example.

[#5]

Appreciate if  you could share the idea in qvw.