topic Re: Pivot Table Doubt in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Doubt/m-p/1356489#M416302 <HTML><HEAD></HEAD><BODY><P>One way of working it out is that add 1 as an additional expression and then hide that column</P><P><A href="https://community.qlik.com/thread/152551">Pivot Column Width to Zero</A></P></BODY></HTML> Mon, 12 Jun 2017 19:50:35 GMT neelamsaroha157 2017-06-12T19:50:35Z Pivot Table Doubt https://community.qlik.com/t5/QlikView/Pivot-Table-Doubt/m-p/1356486#M416299 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>I have below data, which i am trying to project it in Pivot table but not able to display process name having no values in particular week.</P><P></P><P>How can we achieve this ?</P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="201"><TBODY><TR><TD height="20" width="64">Process</TD><TD width="73">Date</TD><TD width="64">Count</TD></TR><TR><TD height="20">P1</TD><TD align="right" class="xl63">01-05-2017</TD><TD align="right">10</TD></TR><TR><TD height="20">P2</TD><TD align="right" class="xl63">01-05-2017</TD><TD align="right">14</TD></TR><TR><TD height="20">P3</TD><TD align="right" class="xl63">02-05-2017</TD><TD align="right">20</TD></TR><TR><TD height="20">P4</TD><TD align="right" class="xl63">03-05-2017</TD><TD align="right">80</TD></TR><TR><TD height="20">P5</TD><TD align="right" class="xl63">08-05-2017</TD><TD align="right">100</TD></TR><TR><TD height="20">P1</TD><TD align="right" class="xl63">08-05-2017</TD><TD align="right">10</TD></TR><TR><TD height="20">P2</TD><TD align="right" class="xl63">08-05-2017</TD><TD align="right">14</TD></TR><TR><TD height="20">P3</TD><TD align="right" class="xl63">08-05-2017</TD><TD align="right">20</TD></TR></TBODY></TABLE><P></P><P>Expected Output in Pivot </P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="192"><TBODY><TR><TD height="20" width="64">Process</TD><TD width="64">Wk1</TD><TD width="64">Count</TD></TR><TR><TD height="20">P1</TD><TD>1-5</TD><TD align="right">10</TD></TR><TR><TD height="20">P2</TD><TD>1-5</TD><TD align="right">14</TD></TR><TR><TD height="20">P3</TD><TD>1-5</TD><TD align="right">20</TD></TR><TR><TD height="20">P4</TD><TD>1-5</TD><TD align="right">80</TD></TR><TR><TD height="20">P5</TD><TD>1-5</TD><TD align="right">0</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 12 Jun 2017 18:45:06 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Doubt/m-p/1356486#M416299 manojkulkarni 2017-06-12T18:45:06Z Re: Pivot Table Doubt https://community.qlik.com/t5/QlikView/Pivot-Table-Doubt/m-p/1356487#M416300 <HTML><HEAD></HEAD><BODY><P>Why is P5 = 0?</P></BODY></HTML> Mon, 12 Jun 2017 18:47:11 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Doubt/m-p/1356487#M416300 sunny_talwar 2017-06-12T18:47:11Z Re: Pivot Table Doubt https://community.qlik.com/t5/QlikView/Pivot-Table-Doubt/m-p/1356488#M416301 <HTML><HEAD></HEAD><BODY><P>P5 doesn't have value in week1 but still need to show all the Process irrespective of data availibility</P></BODY></HTML> Mon, 12 Jun 2017 18:48:09 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Doubt/m-p/1356488#M416301 manojkulkarni 2017-06-12T18:48:09Z Re: Pivot Table Doubt https://community.qlik.com/t5/QlikView/Pivot-Table-Doubt/m-p/1356489#M416302 <HTML><HEAD></HEAD><BODY><P>One way of working it out is that add 1 as an additional expression and then hide that column</P><P><A href="https://community.qlik.com/thread/152551">Pivot Column Width to Zero</A></P></BODY></HTML> Mon, 12 Jun 2017 19:50:35 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Doubt/m-p/1356489#M416302 neelamsaroha157 2017-06-12T19:50:35Z Re: Pivot Table Doubt https://community.qlik.com/t5/QlikView/Pivot-Table-Doubt/m-p/1356490#M416303 <HTML><HEAD></HEAD><BODY><P>Thanks for your reply. I tried this with Macro but when we export the data hidden column will appear.</P><P></P><P>Do we have any other way to do this ?</P></BODY></HTML> Tue, 13 Jun 2017 06:17:17 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Doubt/m-p/1356490#M416303 manojkulkarni 2017-06-13T06:17:17Z