topic Re: Selecting the last 6 weeks in Qlik NPrinting

Selecting the last 6 weeks

Wed, 27 Jul 2016 10:11:44 GMT

Hi,

So I have been trying to setup a report where i select the last 6 weeks. So far i have been able to get the last week with the formula:

=week(now()-7) as a filter.

How can i transform this filter into it selecting the last 6 weeks instead of just the last week?

Thanks in advance.

Re: Selecting the last 6 weeks

sunny_talwar — Wed, 27 Jul 2016 10:15:24 GMT

How about this:

=Week(Now() - 42)

=Week(Today() - 42)

Re: Selecting the last 6 weeks

Wed, 27 Jul 2016 10:22:34 GMT

Hi Sunny,

This doesn't work, I just get the week from 6 weeks ago. But I need to select the last 6 weeks instead of just the week 6 weeks ago.

Re: Selecting the last 6 weeks

Anonymous — Wed, 27 Jul 2016 10:57:31 GMT

Hi,

you can use set analysis for this ..

If you have week number ...

Sum({$<Weekfield={">=$(=(Max(Weekfield) -6))<=$(=(Max(Weekfield)))"}>}sales )

Provided Weekfield is a Week(Datefield)

try this....for last 42 days (6 weeks)

=Sum({<DateField = {">=$(=Date(Today()-42,'MM/DD/YYYY'))<=$(=Date(Today(),'MM/DD/YYYY'))"}>} sales)

Re: Selecting the last 6 weeks

Wed, 27 Jul 2016 11:50:48 GMT

Hi Allu,

Both options are not working for me, maybe im not being clear enough i need this as a filter in N-printing. Or a way to create a filter so that when i run the report in NPrinting it selects the last six weeks minus the week we live in.

Re: Selecting the last 6 weeks

Anil_Babu_Samineni — Wed, 27 Jul 2016 12:00:54 GMT

How about this

Sum({<date ={">=max(date)-42" <=max(date)"}>} Sales)

sum({<date={'>=$(=date(weekstart(max(date)-42)))'}>} Sales)

Re: Selecting the last 6 weeks

sunny_talwar — Wed, 27 Jul 2016 12:19:33 GMT

I don't really know how filters in nPrinting work, but can you do something like this?

='>=' & Week(Today() - 42) & '<=' & Week(Today)

Re: Selecting the last 6 weeks

beginner91 — Fri, 22 Feb 2019 10:55:40 GMT

hello all,

i wanted to see all my bar charts within the last 6 months. when i write =week(now()-42) its just show me 1 bar chart and i wanted to see the last 6 bar charts.