topic Week Number in master calendar in QlikView

Week Number in master calendar

stephenedberkg — Wed, 25 Nov 2020 16:16:04 GMT

i have the date field i want to achieve the output like this.

i am using master calendar.

i want to redefine the week.

i had i attach the qvw file.

in my qvw file 2015 have 53 week but i want 52 weeks only like below output.

2015	2016
WEEKNO	DATE	WEEKNO	DATE
1	12/28/2014	1	12/27/2015
2	1/4/2015	2	1/3/2016
3	1/11/2015	3	1/10/2016
4	1/18/2015	4	1/17/2016
5	1/25/2015	5	1/24/2016
6	2/1/2015	6	1/31/2016
7	2/8/2015	7	2/7/2016
8	2/15/2015	8	2/14/2016
9	2/22/2015	9	2/21/2016
10	3/1/2015	10	2/28/2016
11	3/8/2015	11	3/6/2016
12	3/15/2015	12	3/13/2016
13	3/22/2015	13	3/20/2016
14	3/29/2015	14	3/27/2016
15	4/5/2015	15	4/3/2016
16	4/12/2015	16	4/10/2016
17	4/19/2015	17	4/17/2016
18	4/26/2015	18	4/24/2016
19	5/3/2015	19	5/1/2016
20	5/10/2015	20	5/8/2016
21	5/17/2015	21	5/15/2016
22	5/24/2015	22	5/22/2016
23	5/31/2015	23	5/29/2016
24	6/7/2015	24	6/5/2016
25	6/14/2015	25	6/12/2016
26	6/21/2015	26	6/19/2016
27	6/28/2015	27	6/26/2016
28	7/5/2015	28	7/3/2016
29	7/12/2015	29	7/10/2016
30	7/19/2015	30	7/17/2016
31	7/26/2015	31	7/24/2016
32	8/2/2015	32	7/31/2016
33	8/9/2015	33	8/7/2016
34	8/16/2015	34	8/14/2016
35	8/23/2015	35	8/21/2016
36	8/30/2015	36	8/28/2016
37	9/6/2015	37	9/4/2016
38	9/13/2015	38	9/11/2016
39	9/20/2015	39	9/18/2016
40	9/27/2015	40	9/25/2016
41	10/4/2015	41	10/2/2016
42	10/11/2015	42	10/9/2016
43	10/18/2015	43	10/16/2016
44	10/25/2015	44	10/23/2016
45	11/1/2015	45	10/30/2016
46	11/8/2015	46	11/6/2016
47	11/15/2015	47	11/13/2016
48	11/22/2015	48	11/20/2016
49	11/29/2015	49	11/27/2016
50	12/6/2015	50	12/4/2016
51	12/13/2015	51	12/11/2016
52	12/20/2015	52	12/18/2016
53	12/25/2016

Re: Week Number in master calendar

migueldelval — Wed, 29 Jun 2016 10:16:48 GMT

Hi Stephen,

Could you attach xlsx file, please? Or say me what are the labels?

Regards

Miguel del Valle

Re: Week Number in master calendar

stephenedberkg — Wed, 29 Jun 2016 10:29:26 GMT

Hi migueldelval

PFA sheet1 is expected output

sheet 2 is the input for qvw

Re: Week Number in master calendar

migueldelval — Wed, 29 Jun 2016 10:38:36 GMT

Hi Stephen,

Look if it´s correct this example.

Regards

Miguel del Valle

Re: Week Number in master calendar

stephenedberkg — Wed, 29 Jun 2016 10:48:32 GMT

Dear migueldelval

Thanks for your reply

Its not correct.

i tried below expression in script

if(Week(TempDate) = 53,'1',Week(TempDate)) as Week_UP1,Week(TempDate) AS Week_UP,

its working correctly but 2015 & 2016 also its take 1st week.

Re: Week Number in master calendar

migueldelval — Wed, 29 Jun 2016 10:56:21 GMT

Hi Stephen,

Try this example, please.

Regards

Miguel del Valle

Re: Week Number in master calendar

stephenedberkg — Wed, 29 Jun 2016 11:13:11 GMT

Dear migueldelval

I am using personal edition i cant open this Qvw file .

please send the screen shot.

Regards

Stephe Edberk

Re: Week Number in master calendar

migueldelval — Wed, 29 Jun 2016 11:16:00 GMT

Hi Stephen,

This expression: If(Week(TempDate)<53 and Week(TempDate)<>0,week(TempDate)) AS Week_UP,

Regards

Miguel del Valle

Re: Week Number in master calendar

stephenedberkg — Wed, 29 Jun 2016 11:25:51 GMT

Dear migueldelval

i want to take this( 12/27/2015) date as 1st week of 2016.

2014 should have only 52 weeks only

Re: Week Number in master calendar

migueldelval — Wed, 29 Jun 2016 11:29:51 GMT

Hi Stephen,

Then Read this document, I think that apply in your question.

Redefining the Week Numbers

Regards

Miguel del Valle