topic Re: Month Week ( 1 to 4 or 5 weeks) in QlikView

Month Week ( 1 to 4 or 5 weeks)

Thu, 26 Apr 2012 10:04:04 GMT

Hi,

Do you have any idea how to make the monthly week into

Week 1, Week 2, Week 3, Week 4, Week 5

Rather than, week 1 to week 52

Say for example...

January

Week 1

Week 2

Week 3

Week 4

February

Week 1

Week 2

Week 3

Week 4

Is this possible? Please help me... Because the client want it that way...

Thanks.

Best Regards,

Bill

Re: Month Week ( 1 to 4 or 5 weeks)

jagannalla — Thu, 26 Apr 2012 10:08:12 GMT

Hello,

If you have dates in the field, you can do this using week function.

For eg:

DateField

01-01-2012

02-01-2012

Load Week(DateField) as WeekNumber

From Table;

If you want to get week name

Use as

Load 'Week'&Week(DateField) as WeekNumber

From Table;

Month Week ( 1 to 4 or 5 weeks)

CELAMBARASAN — Thu, 26 Apr 2012 10:08:52 GMT

Hi,

Check with this

'Week'&Ceil(Day(Date)/7) as MonthlyWeek

Celambarasan

Month Week ( 1 to 4 or 5 weeks)

Thu, 26 Apr 2012 10:35:33 GMT

Thanks Celambarasan...

Thanks for the info Jagan...

Re: Month Week ( 1 to 4 or 5 weeks)

kroberts13 — Tue, 27 Sep 2016 18:27:24 GMT

Is there a way to do this for 4 weeks rather than 5?

Re: Month Week ( 1 to 4 or 5 weeks)

Wed, 05 Jul 2017 10:21:08 GMT

I made this calculation for a project and used the following piece of code

(Week(MonthEnd(Date)) - Week(MonthStart(Date))) - (Week(MonthEnd(Date)) - Week(Date)) + 1 as WeekMonth

where Date is the dates that I have in a list.

Hope it helps

Re: Month Week ( 1 to 4 or 5 weeks)

MarioWang — Wed, 30 Dec 2020 03:43:21 GMT

Thanks a lot.This is what I need.