Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

make a week number a proper weekending date e.g. 'DD-MM'YYY'

hi does anyone know how i can convert a week number (0-52) into a weekending date?

e.g. week number 1 = weekending 10-04-2011

how can i write a formula so that week 1 can be '10-04-2011'

similarly week 2 to appear as 17-04-2011'

any ideas?

4 Replies
Highlighted
Not applicable

Hi,

you could use makeweekdate() for that and then weekend().

So i.e.: weekend(MakeWeekDate(2011,1))

Does this solve your question?

Cheers,

Gerald

================================

http://www.globeqlik.com

Join the GlobeQlik- User Group here

Highlighted
Not applicable

Hi, I'm guessing you might have weekyear date in the following format YYYYWW (e.g. 201101), then you could use a expression similar to the following:

date(weekend(MakeWeekDate(left(WeekYearField,4),right(WeekYearField,2))),'DD-MM-YYYY')

Regards

Highlighted
Partner
Partner

Helpful thanks.

Highlighted
Contributor III
Contributor III

Thanks for expression.