Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Total we have two problems
1. Qlikview considering the 53rd week as week 1 of next year.
2. Last 5 weeks and 20 weeks are not working due to this 53rd week.
We are in 53rd week now.(i,e 3 days.. 29th, 30th and 31st of 2014)
This is backlog report.
Currently in my application the data is displaying week wise. In time dimension we have 53 weeks which is taking from DB. but when i click on current week in application its not showing any data because qlikview is considering this as week 1 of 2015.
and we have another requirement of last 5 weeks and 20 weeks, it is also not working due to this 53rd week issue.
Currently we are using the below script for 20 weeks.
LET CW = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY()));
LET CW1 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-1);
LET CW2 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-2);
LET CW3 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-3);
LET CW4 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-4);
LET CW5 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-5);
LET CW6 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-6);
LET CW7 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-7);
LET CW8 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-8);
LET CW9 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-9);
LET CW10 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-10);
LET CW11 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-11);
LET CW12 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-12);
LET CW13 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-13);
LET CW14 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-14);
LET CW15 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-15);
LET CW16 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-16);
LET CW17 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-17);
LET CW18 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-18);
LET CW19 = YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-19);
LET CW20= YEAR(TODAY()) & '-' & 'W' & CEIL(Week(TODAY())-20);
Please advise how to resolve or achieve this. thanks in advance
Srini.