topic Re: Pivot table in QlikView https://community.qlik.com/t5/QlikView/Pivot-table/m-p/406982#M151404 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> Drag the year field and leave it near the expression like the example<IMG __jive_id="26435" class="jive-image-thumbnail jive-image" onclick="" alt="untitled.bmp" src="https://community.qlik.com/legacyfs/online/26435_untitled.bmp" width="450" /></P></BODY></HTML> Tue, 04 Dec 2012 21:52:16 GMT MayilVahanan 2012-12-04T21:52:16Z Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/406981#M151403 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>I want create a pivot table like :</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="800"><TBODY><TR><TD class="xl66" colspan="2" height="40" rowspan="2" width="160"><BR /></TD><TD class="xl64" colspan="2" width="160">2012</TD><TD class="xl64" colspan="2" style="border-left: none;" width="160">2011</TD><TD class="xl64" colspan="2" style="border-left: none;" width="160">2010</TD><TD class="xl64" colspan="2" style="border-left: none;" width="160">Total</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD></TR><TR><TD class="xl67" height="60" rowspan="3" style="border-bottom: .5pt solid black;">ABC</TD><TD class="xl63" style="border-left: none;">Rep</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">5</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">7</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">14</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl63" height="20" style="border-top: none; border-left: none;">Com</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">9</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">5</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">12</TD></TR><TR><TD class="xl63" height="20" style="border-top: none; border-left: none;">Total</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">7</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">9</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">15</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">7</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">19</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">22</TD></TR><TR><TD class="xl67" height="60" rowspan="3" style="border-bottom: .5pt solid black; border-top: none;">ABD</TD><TD class="xl63" style="border-top: none; border-left: none;">Rep</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">12</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">65</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">34</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">46</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">71</TD></TR><TR><TD class="xl63" height="20" style="border-top: none; border-left: none;">Com</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">5</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">9</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">7</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">15</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">12</TD></TR><TR><TD class="xl63" height="20" style="border-top: none; border-left: none;">Total</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">5</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">21</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">72</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">40</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">61</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">83</TD></TR></TBODY></TABLE><P></P><P>Any idea or way to do it.</P><P></P><P>Many thanks for your help.</P><P></P><P>Regards,</P><P></P><P>Emteam</P></BODY></HTML> Tue, 04 Dec 2012 21:47:50 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/406981#M151403 emteam162 2012-12-04T21:47:50Z Re: Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/406982#M151404 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> Drag the year field and leave it near the expression like the example<IMG __jive_id="26435" class="jive-image-thumbnail jive-image" onclick="" alt="untitled.bmp" src="https://community.qlik.com/legacyfs/online/26435_untitled.bmp" width="450" /></P></BODY></HTML> Tue, 04 Dec 2012 21:52:16 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/406982#M151404 MayilVahanan 2012-12-04T21:52:16Z Re: Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/406983#M151405 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Thanks for your replay, but dosen't work</P><P>and i can't have my pivot table </P><P></P><P>Regards,</P><P></P><P>Emteam</P></BODY></HTML> Tue, 04 Dec 2012 22:02:36 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/406983#M151405 emteam162 2012-12-04T22:02:36Z Re: Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/406984#M151406 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Can u provide a sample?</P></BODY></HTML> Tue, 04 Dec 2012 22:25:57 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/406984#M151406 MayilVahanan 2012-12-04T22:25:57Z Re: Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/406985#M151407 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>see attached</P><P></P><P>Many thanks</P><P></P><P>Emteam</P></BODY></HTML> Tue, 04 Dec 2012 23:19:52 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/406985#M151407 emteam162 2012-12-04T23:19:52Z Re: Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/406986#M151408 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Any idee, please???</P><P></P><P>Many thanks</P><P></P><P>Emteam</P></BODY></HTML> Wed, 05 Dec 2012 18:33:09 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/406986#M151408 emteam162 2012-12-05T18:33:09Z