Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
sqlpuzzle
New Contributor III

year and weekofyear to MMM-dd-YYYY format

Hi,

 

I have a data set that has  year and weekof year in it. I need to derive two fields,

week begin date (MMM-dd-YYYY) format

week end date (MMM-dd-YYYY) format.

Is this possible?

I am attaching my sample

Labels (1)
1 Solution

Accepted Solutions
ThePeterK
New Contributor III

Re: year and weekofyear to MMM-dd-YYYY format

Does this get you what you need?:

 

=weekstart(date(YearStart(makedate(2019))+weekofyear*7))

=weekend(date(YearStart(makedate(2019))+weekofyear*7))

93/93
1 Reply
ThePeterK
New Contributor III

Re: year and weekofyear to MMM-dd-YYYY format

Does this get you what you need?:

 

=weekstart(date(YearStart(makedate(2019))+weekofyear*7))

=weekend(date(YearStart(makedate(2019))+weekofyear*7))

93/93