Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi Stephen,
Could you attach xlsx file, please? Or say me what are the labels?
Regards
Miguel del Valle
Hi Stephen,
Look if it´s correct this example.
Regards
Miguel del Valle
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.
Hi Stephen,
Try this example, please.
Regards
Miguel del Valle
Dear migueldelval
I am using personal edition i cant open this Qvw file .
please send the screen shot.
Regards
Stephe Edberk
Hi Stephen,
This expression: If(Week(TempDate)<53 and Week(TempDate)<>0,week(TempDate)) AS Week_UP,
Regards
Miguel del Valle
Dear migueldelval
i want to take this( 12/27/2015) date as 1st week of 2016.
2014 should have only 52 weeks only
Hi Stephen,
Then Read this document, I think that apply in your question.
Regards
Miguel del Valle