Discussion Board for collaboration related to Creating Analytics for QlikView.
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...
Is this possible? Please help me... Because the client want it that way...
Check with this
'Week'&Ceil(Day(Date)/7) as MonthlyWeek
View solution in original post
If you have dates in the field, you can do this using week function.
Load Week(DateField) as WeekNumber
If you want to get week name
Load 'Week'&Week(DateField) as WeekNumber
Thanks for the info Jagan...
Is there a way to do this for 4 weeks rather than 5?
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