topic Re: Find month name from week number in QlikView

Find month name from week number

neha_sri — Mon, 25 Aug 2014 16:47:34 GMT

Hi,

I have week number and I want to calculate month name from it.Can I do so...

Anonymous — Mon, 25 Aug 2014 17:08:49 GMT

You can, but week number is not enough.

First, week may belong to two months, so you need to tell what day of the week defines the month - Monday, or Sunday, or....

Second, you need to know the year. Same week number could be in different months in the different years.

alematex — Mon, 25 Aug 2014 17:17:25 GMT

=MakeWeekDate(2014,34)

returns last monday

alematex — Mon, 25 Aug 2014 17:18:35 GMT

MakeWeekDate(2014,34,3)

returns thursday 0-Monday 6-Sunday

MarcoWedel — Mon, 25 Aug 2014 17:29:46 GMT

Hi,

using a combination of MakeWeekDate and MonthName delivers the month name:

=MonthName(MakeWeekDate(Year, Week))

hope this helps

regards

Marco