topic Re: Filter on last weeks in QlikView

Filter on last weeks

pascaldijkshoor — Tue, 13 Feb 2018 15:27:12 GMT

Hello,

I want a filter that filters on the last couple of weeks (for example the last 5 weeks). This filter will be used on graphs that compare 2017 with 2018, So I want to compare week 2-6 of 2017 and week 2-6 of 2018 with each other. I tried to use the weeksago function but then it only shows the last 5 weeks in 2018 and not those weeks in 2017. Does anyone have a solution for this?

Thanks,

Pascal

Re: Filter on last weeks

YoussefBelloum — Tue, 13 Feb 2018 15:32:38 GMT

Hi,

can you tell us more about your table structure ?

what are the Date columns you have ?

can you attach an example app? sample data ?

Re: Filter on last weeks

pascaldijkshoor — Tue, 13 Feb 2018 15:56:35 GMT

I have bar chart with week dimensions on the X-axis (W01, W02, W03,...) and a measure that calculates the difference between 2017 and 2018 on the Y-axis.

Re: Filter on last weeks

YoussefBelloum — Tue, 13 Feb 2018 15:59:55 GMT

this Week dimension (W01, W02...) is it a derived field of a "formatted" "date field?

Re: Filter on last weeks

pascaldijkshoor — Wed, 14 Feb 2018 09:37:52 GMT

Yes it is

Re: Filter on last weeks

YoussefBelloum — Wed, 14 Feb 2018 10:15:35 GMT

Hi,

here you can find one method to do it

=sum({<Year={'$(=Max(Year))'}, Week={">=$(=Week(today())-5)<$(=Week(today()))"}>}myRandom) ==> for last 5 weeks of N

=sum({<Year={'$(=Max(Year)-1)'}, Week={">=$(=Week(today())-5)<$(=Week(today()))"}>}myRandom) ==> for last 5 weeks of N-1

Please find attached

Re: Filter on last weeks

YoussefBelloum — Wed, 14 Feb 2018 10:24:48 GMT

and with this one you have can change dynamically the numbers of the weeks

please find attached