Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
CELAMBARASAN
Partner
Partner

Hi,

Check with this

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

Celambarasan

View solution in original post

6 Replies
jagannalla
Partner
Partner

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;

CELAMBARASAN
Partner
Partner

Hi,

Check with this

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

Celambarasan

View solution in original post

Not applicable
Author

Thanks Celambarasan...

Thanks for the info Jagan...

kroberts13
Contributor III
Contributor III

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

Not applicable
Author

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

MarioWang
Partner
Partner

Thanks a lot.This is what I need.