Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Month Week ( 1 to 4 or 5 weeks)

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

Tags (2)
1 Solution

Accepted Solutions

Month Week ( 1 to 4 or 5 weeks)

Hi,

Check with this

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

Celambarasan

View solution in original post

5 Replies
Partner
Partner

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

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)

Hi,

Check with this

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

Celambarasan

View solution in original post

Not applicable

Month Week ( 1 to 4 or 5 weeks)

Thanks Celambarasan...

Thanks for the info Jagan...

kroberts13
New Contributor III

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

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

Not applicable

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

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