topic Re: make a week number a proper weekending date e.g. 'DD-MM'YYY' in QlikView

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

Wed, 01 Jun 2011 16:10:59 GMT

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?

Wed, 01 Jun 2011 16:38:08 GMT

Hi,

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

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

Does this solve your question?

Cheers,

Gerald

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

Join the GlobeQlik- User Group here

Wed, 01 Jun 2011 16:58:25 GMT

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

reanfadyl — Tue, 26 Apr 2016 20:42:52 GMT

Helpful thanks.

Anonymous — Thu, 19 May 2016 02:25:30 GMT

Thanks for expression.