topic Re: Monthwise Week in QlikView

Monthwise Week

QlikAngel — Thu, 13 Aug 2015 11:49:51 GMT

Hello,

I need Monthwise week seperation.

e.g

in Aug month as per calendar, it should display 6 weeks

as Week1, week2 and so on...

So how to do that ?

Re: Monthwise Week

parthakk — Thu, 13 Aug 2015 11:52:14 GMT

sorry 6 weeks in Aug month???

Re: Monthwise Week

MK_QSL — Thu, 13 Aug 2015 12:15:36 GMT

Something like below?

Let vMinDate = Num(YearStart(Today()));
Let vMaxDate = Num(YearEnd(Today()));


Date:
Load
  Date,
  WeekDay(Date) as Day,
  If(Date = MonthStart(Date),1) as Week;
Load
  Date($(vMinDate) + IterNo() - 1) as Date
AutoGenerate 1 
While $(vMinDate) + IterNo() - 1 <= $(vMaxDate);


Final:
Load
  Date,
  Month(Date) as Month,
  Year(Date) as Year,
  If(Week=1, Week,
  If(Day = 'Mon', RangeSum(Peek('Week'),1),Peek('Week'))) as Week
Resident Date
Order By Date;


Drop Table Date;

Re: Monthwise Week

QlikAngel — Mon, 17 Aug 2015 06:40:02 GMT

Hi,

Thanks for the help.

I have applied same logic in my application but I am getting multiple weeks instead of 6 weeks as per your script.

Please check the attached application as its not worked... please help @ manish !

Thanks in advance,

Mayuri.

Re: Monthwise Week

MK_QSL — Mon, 17 Aug 2015 09:52:15 GMT

You have to use WeekNum as your final Week Field... Not Week !

Re: Monthwise Week

QlikAngel — Mon, 17 Aug 2015 10:45:28 GMT

Hello,

I have also done using week, but still its giving multiple week.

Thanks ,

Mayuri

Re: Monthwise Week

MK_QSL — Mon, 17 Aug 2015 10:48:52 GMT

Upload the file after running the script. I am unable to see WeekNum

Re: Monthwise Week

QlikAngel — Mon, 17 Aug 2015 12:17:43 GMT

Thanks Manish... There was Date Problem