topic Jan 1 Always Week 1 in QlikView

Jan 1 Always Week 1

Tue, 30 Apr 2013 02:26:15 GMT

can you give me a script on how to set

Jan 1 is always Week 1 every Year

thank you

tresB — Tue, 30 Apr 2013 04:42:08 GMT

Hello,

Have you tried week function?

Thanks.

sushil353 — Tue, 30 Apr 2013 04:57:34 GMT

Hi,

try this:

get the month start date from monthstart() and then subtract 7 days from that.

HTH

Sushil

Tue, 30 Apr 2013 05:47:39 GMT

you can use

Div(date-YearStart(date)+WeekDay(YearStart(date))+7,7) as WeekNumber

This will always return week 1 for Jan 1st. It will use Monday as the first day of the week.

If you want Sunday as the first day of the week, you should use

Div(date-YearStart(date) + WeekDay(YearStart(date)+1) +7,7) as WeekNumber

jagan — Tue, 30 Apr 2013 08:14:40 GMT

Hi,

Try LunarWeekName()

=Right(LunarWeekName(MakeDate(2012, 1)), 2)

Hope it helps you.

Regards,

Jagan.