topic Re: Weekly Date Range in QlikView

Weekly Date Range

Anonymous — Tue, 06 May 2014 16:55:43 GMT

I am new to Qlikview. I need to create a report of the number of open and closed accounts for a weekly period - Sunday thru Saturday. How is the best way to define the weekly periods so I can select the week or weeks from a Multibox on my QlikView sheet to filter my table and or chart? I see the WeekName function, but that only gives me a YYYY_## format of year and week number. Is there any way to actually show the beginning and ending dates for each week in the Multibox?

Thanks for your help.

Re: Weekly Date Range

swuehl — Tue, 06 May 2014 17:02:13 GMT

Try something like

LOAD

Date,

dual( WeekStart(Date, 0 ,-1) & ' - ' & WeekEnd(Date, 0 ,-1), Weekstart(Date, 0 ,-1) ) as WeekStartEnd,

...

FROM ...;

Re: Weekly Date Range

Anonymous — Tue, 06 May 2014 17:08:17 GMT

PERFECT! Thank you.

Re: Weekly Date Range

qlikvw2019 — Fri, 27 Sep 2019 16:06:52 GMT

Hi ,

I have the same requirement , looking to display the weekly data. came across this thread .

When i use this code , i am getting error msg "Date not found"