Discussion Board for collaboration related to QlikView App Development.
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'
you could use makeweekdate() for that and then weekend().
So i.e.: weekend(MakeWeekDate(2011,1))
Does this solve your question?
Join the GlobeQlik- User Group here
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:
Thanks for expression.