topic Re: Week Question.....??? in QlikView

Week Question.....???

aveeeeeee7en — Wed, 25 Mar 2015 09:05:07 GMT

Hi All

See my Requirement below:

See the Attached qvw.

Regards

Av7eN

Re: Week Question.....???

Gysbert_Wassenaar — Wed, 25 Mar 2015 09:15:56 GMT

ABC:
LOAD *, AutoNumber(New_Week, New_MonthName) as New_MonthWeek;
LOAD *,
    'Week'&Ceil(Day(New_Date)/7) as  MonthlyWeek,
    Week(New_Date) AS New_Week,
    WeekDay(New_Date) AS New_WeekDay,
    WeekEnd(New_Date) AS New_WeekEnd,
    WeekName(New_Date) AS New_WeekName,   
    MonthName(New_Date) AS New_MonthName,
    Day(New_Date) AS New_Day;
LOAD
    Date(MakeDate(2015,1,1)+RecNo()-1,'DD/MM/YYYY') AS New_Date
AutoGenerate(365);

See attached example.

Re: Week Question.....???

aveeeeeee7en — Wed, 25 Mar 2015 09:22:05 GMT

Thank You Sir.

Regards

Av7eN

Re: Week Question.....???

aveeeeeee7en — Wed, 25 Mar 2015 10:16:53 GMT

Dear Sir

The below difference is coming in February & March Month when I am Selecting Week 1.

Feb & March both have first day Sunday.

Regards

Av7eN

Re: Week Question.....???

Gysbert_Wassenaar — Wed, 25 Mar 2015 10:25:04 GMT

Works fine for me in the example I posted.

Re: Week Question.....???

aveeeeeee7en — Wed, 25 Mar 2015 10:37:46 GMT

Dear Sir

Also, Nov 2014 Data is coming Wrong.

See Week1 Data for Nov 2014:

Sir,

See the Attached qvw.

Regards

Av7eN

Re: Week Question.....???

Gysbert_Wassenaar — Wed, 25 Mar 2015 10:55:35 GMT

Change the BBB load to:

BBB:

LOAD DISTINCT *,

Week(UPDATE_DATE) AS New_Week,

MonthName(UPDATE_DATE) AS New_MonthName

Resident ABC

ORDER BY UPDATE_DATE;

Re: Week Question.....???

aveeeeeee7en — Wed, 25 Mar 2015 11:02:33 GMT

Not Working.

I am getting strange results now.

Causing Problem for March 2015.

Re: Week Question.....???

Gysbert_Wassenaar — Wed, 25 Mar 2015 11:36:19 GMT

Post the source file.

Re: Week Question.....???

anbu1984 — Wed, 25 Mar 2015 11:52:41 GMT

Check my solution here Week Logic Requirement..............???