Calendar greater than or equal to 7 weeks ago and less than or equal to 2 weeks ago

[bobbydave]

Find attached my calendar.

What I am trying to achieve is to get the last 6 weeks previous to last week.

I am using Dual as previously advised. If you then look at my output in calendar, if i click on the

>=week <=week,

I'd imagine that it would show the weeks of those last 6 weeks, but it only shows the current week.

My expression in the script is in the comment section on the T_Calendar tab, further on down the page.

Any ideas?

[bobbydave]

Anyone with any ideas?

[omkarvamsi]

try this logic in script

if(week(Tdate)<= week(today()) and week(Tdate)>=week(today())-6,1,0) as Last_seven_week_Flag

[rohitraut · Accepted solution]

Hello David,

Please find the  .qvw.

Hope this works!

[Anonymous]

Hi David,

I edited the title of this post to remove the ">=" and "<=" signs because it was causing the page to display in an unusual way.

Best regards,

Qlik Community Team