Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Anyone with any ideas?
try this logic in script
if(week(Tdate)<= week(today()) and week(Tdate)>=week(today())-6,1,0) as Last_seven_week_Flag
Hello David,
Please find the .qvw.
Hope this works!
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