Weekly Date Range

[Anonymous]

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.

Ed

[swuehl · Accepted solution]

Try something like

LOAD

     Date,

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

     ...

FROM ...;

[Anonymous]

PERFECT!  Thank you.

[qlikvw2019]

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"