Jan 1 Always Week 1 - Qlik Community

Report Inappropriate Content · ‎2013-04-29

can you give me a script on how to set

Jan 1 is always Week 1 every Year

thank you

tresesco · ‎2013-04-30

Hello,

Have you tried week function?

Thanks.

sushil353 · ‎2013-04-30

Hi,

try this:

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

HTH

Sushil

Report Inappropriate Content · ‎2013-04-30

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 · ‎2013-04-30

Hi,

Try LunarWeekName()

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

Hope it helps you.

Regards,

Jagan.