topic Re: Week Logic Requirement..............??? in QlikView

Week Logic Requirement..............???

aveeeeeee7en — Wed, 25 Mar 2015 05:56:32 GMT

Dear All

I need to Categorize the Weeks for every month as Week1, Wee2,.........

If I use this:

'Week'&Ceil(Day(New_Date)/7) as Weeks

than i am getting the Weeks as Week1, Week2,......

but the problem with this is it is calculating the Weeks as Week1 = 1-7, Week2 = 8-14..................

I don't want this.

I want to calculate Weeks as: Suppose take a example for January 2015 than:

Week1 = Thu, Fri, Sat, Sun (1,2,3,4)

Week1 = Mon, Tues, Wed, Thu, Fri, Sat, Sun (5,6,7,8,9,10,11)............................

Please find the enclosed Sample File for reference.

Regards

Av7eN

aveeeeeee7en — Wed, 25 Mar 2015 06:26:19 GMT

Any Suggestion??

anbu1984 — Wed, 25 Mar 2015 07:02:30 GMT

Src:

LOAD Required???,

WeekDay,

SampleDate,

WeekNumber,

Week(SampleDate) As WeekNo

FROM

[Sample File.xlsx]

(ooxml, embedded labels, table is Sheet1);

Join(Src)

Load WeekNo,'Week'&AutoNumber(RecNo(),Mth) As Weeks ;

Load WeekNo,Max(Month(SampleDate)) as Mth Resident Src Group by WeekNo Order by WeekNo asc;