topic Re: Filter data weekly in QlikView

Filter data weekly

Tue, 22 Jul 2014 09:53:21 GMT

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

Re: Filter data weekly

senpradip007 — Tue, 22 Jul 2014 10:00:49 GMT

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

QV 11.

Re: Filter data weekly

juleshartley — Tue, 22 Jul 2014 10:10:05 GMT

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

Re: Filter data weekly

Tue, 22 Jul 2014 11:17:00 GMT

Could you please give me an example.

Re: Filter data weekly

Tue, 22 Jul 2014 11:17:58 GMT

Appreciate if you could share the idea in qvw.