Number of Weeks

[poooja]

Hi Qlikies,

Please help me with some logic for the  Broken weeks . I am expecting the result as Below.

'Total Number of weeks in the current month.

WeekNumber	Day	Date	Budget
1	Friday	1/4/2019	500
2	Friday	1/11/2019	500
3	Friday	1/18/2019	500
4	Friday	1/25/2019	500
5	Thursday	1/31/2019	500
1	Friday	2/8/2019	600
2	Friday	2/15/2019	600
3	Friday	2/22/2019	600
4	Thursday	2/28/2019	600
1	Friday	3/8/2019	400
2	Friday	3/15/2019	400
3	Friday	3/22/2019	400
4	Sunday	3/31/2019	400
1	Friday	4/5/2019	800
2	Friday	4/12/2019	800
3	Friday	4/19/2019	800
4	Friday	4/26/2019	800
5	Tuesday	4/30/2019	800
1	Friday	5/10/2019	400
2	Friday	5/17/2019	400
3	Friday	5/24/2019	400
4	Friday	5/31/2019	400
1	Friday	6/7/2019	700
2	Friday	6/14/2019	700
3	Friday	6/21/2019	700
4	Sunday	6/30/2019	700
1	Friday	7/5/2019	300
2	Friday	7/12/2019	300
3	Friday	7/19/2019	300
4	Friday	7/26/2019	300
5	Wednesday	7/31/2019	300
1	Friday	8/9/2019	500
2	Friday	8/16/2019	500
3	Friday	8/23/2019	500
4	Saturday	8/31/2019	500
1	Friday	9/6/2019	900
2	Friday	9/13/2019	900
3	Friday	9/27/2019	900
4	Monday	9/30/2019	900
1	Friday	10/4/2019	900
2	Friday	10/11/2019	200
3	Friday	10/18/2019	200
4	Friday	10/25/2019	200
5	Thursday	10/31/2019	200
1	Friday	11/8/2019	400
2	Friday	11/15/2019	400
3	Friday	11/22/2019	400
4	Saturday	11/30/2019	400
1	Friday	12/6/2019	500
2	Friday	12/13/2019	500
3	Friday	12/20/2019	500
4	Friday	12/27/2019	500
5	Friday	12/31/2019	500

[Vegar]

Try this:

QlikCommunityTable:
LOAD //WeekNumber, 
     Day, 
     num(Date) as %date, 
     Budget
FROM
[https://community.qlik.com/t5/QlikView-App-Development/Number-of-Weeks/m-p/1553953#M440500]
(html, codepage is 1252, embedded labels, table is @1);

for _date = date('1/4/2019') to date('12/31/19')
	Calendar:
	LOAD 
		'$(_date)' as %date,
		date('$(_date)') as Date,
		weekname('$(_date)')   as WeekName,
		week('$(_date)')   as Week,
		autonumber(weekname('$(_date)') , 'ws')  - autonumber( weekname( monthstart('$(_date)')), 'ws') +1  as WeekNumber
	AutoGenerate 1;	
next

I do get a diff  from you. Eg 2/8/2019, I get WeekNumber = 2 and in your table it is = 1, but if you study the calendar you'll see that it is the second week in February.

[poooja]

Hi,

In your output we are missing week number 1 for most of the months.  eg 2/8/2019, Tough its second week in February calendar I am combining the first week also since it has only  2 days.  

Thanks!

Pooja