topic Issue in displaying weeks in Pivot Table - Please help !! in QlikView https://community.qlik.com/t5/QlikView/Issue-in-displaying-weeks-in-Pivot-Table-Please-help/m-p/633029#M1088463 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a table where it displays YYYYPMM and weeks in Pivot table.</P><P></P><P>Issue is this..</P><P></P><P>If there is a week in 2 months, its being displayed two times, 1 in each month, but i want it to occur only once. Can somebody help me ?</P><P></P><P>Sample 1 excel is data as per issue.</P><P></P><P>I need it in this way :</P><P></P><P>in beloqw image, week 31 lies in both month P7 and P8.</P><P><IMG alt="sample.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/59766_sample.jpg" style="width: 620px; height: 496px;" /></P><P></P><P><BR /> </P></BODY></HTML> Thu, 29 May 2014 14:16:10 GMT 2014-05-29T14:16:10Z Issue in displaying weeks in Pivot Table - Please help !! https://community.qlik.com/t5/QlikView/Issue-in-displaying-weeks-in-Pivot-Table-Please-help/m-p/633029#M1088463 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a table where it displays YYYYPMM and weeks in Pivot table.</P><P></P><P>Issue is this..</P><P></P><P>If there is a week in 2 months, its being displayed two times, 1 in each month, but i want it to occur only once. Can somebody help me ?</P><P></P><P>Sample 1 excel is data as per issue.</P><P></P><P>I need it in this way :</P><P></P><P>in beloqw image, week 31 lies in both month P7 and P8.</P><P><IMG alt="sample.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/59766_sample.jpg" style="width: 620px; height: 496px;" /></P><P></P><P><BR /> </P></BODY></HTML> Thu, 29 May 2014 14:16:10 GMT https://community.qlik.com/t5/QlikView/Issue-in-displaying-weeks-in-Pivot-Table-Please-help/m-p/633029#M1088463 2014-05-29T14:16:10Z Re: Issue in displaying weeks in Pivot Table - Please help !! https://community.qlik.com/t5/QlikView/Issue-in-displaying-weeks-in-Pivot-Table-Please-help/m-p/633030#M1088464 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>I guess there are also days in the data.</P><P>So when you change the date text format the days are still there.</P><P>You have to 'round' your dates on a weekly basis.</P></BODY></HTML> Thu, 29 May 2014 20:31:18 GMT https://community.qlik.com/t5/QlikView/Issue-in-displaying-weeks-in-Pivot-Table-Please-help/m-p/633030#M1088464 whiteline 2014-05-29T20:31:18Z Re: Issue in displaying weeks in Pivot Table - Please help !! https://community.qlik.com/t5/QlikView/Issue-in-displaying-weeks-in-Pivot-Table-Please-help/m-p/633031#M1088465 <HTML><HEAD></HEAD><BODY><P>Your attached example is not the same as the screen dump.</P><P>How did you arrive at the weeks number anyway?</P></BODY></HTML> Thu, 29 May 2014 21:25:34 GMT https://community.qlik.com/t5/QlikView/Issue-in-displaying-weeks-in-Pivot-Table-Please-help/m-p/633031#M1088465 robert_mika 2014-05-29T21:25:34Z