topic Re: Pivot Table in Management & Governance

topic Re: Pivot Table in Management & Governance https://community.qlik.com/t5/Management-Governance/Pivot-Table/m-p/1231217#M17822 <HTML><HEAD></HEAD><BODY><P>Check this out!</P><P></P><P>Fei</P></BODY></HTML> Fri, 11 Nov 2016 03:49:23 GMT NZFei 2016-11-11T03:49:23Z Pivot Table https://community.qlik.com/t5/Management-Governance/Pivot-Table/m-p/1231216#M17821 <HTML><HEAD></HEAD><BODY><P>Hi team ,</P><P></P><P>I have small doubt in accomplishing a one task .</P><P></P><P>I have my table structure in a DB as below </P><P></P><P>  </P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><TBODY><TR><TD class="xl65" height="20" width="64">Plant</TD><TD class="xl65" style="border-left: none;" width="64">week </TD><TD class="xl65" style="border-left: none;" width="64">Supply </TD><TD class="xl65" style="border-left: none;" width="64">Demand</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">A</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">50</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;"> </TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">25</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">30</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;"> </TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">12</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;"> </TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">45</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">300</TD></TR></TBODY></TABLE><P></P><P></P><P>I need my table structure in qlik sense as </P><P>  </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 384px;"><TBODY><TR><TD class="xl65" height="20" width="64"> </TD><TD class="xl65" style="border-left: none;" width="64"> </TD><TD class="xl65" style="border-left: none;" width="64">Weeks</TD><TD class="xl65" style="border-left: none;" width="64"> </TD><TD class="xl65" style="border-left: none;" width="64"> </TD><TD class="xl65" style="border-left: none;" width="64"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Plant </TD><TD class="xl65" style="border-top: none; border-left: none;">Value</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">Supply </TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">25</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">12</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">45</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;"> </TD><TD class="xl65" style="border-top: none; border-left: none;">DEMAND</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">50</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">300</TD></TR></TBODY></TABLE><P></P><P></P><P>Basically i would like to transpose column header as rows and column values as measure .</P><P></P><P></P><P>Thanks,</P><P>Anuradha</P></BODY></HTML> Sat, 16 Nov 2024 10:15:45 GMT https://community.qlik.com/t5/Management-Governance/Pivot-Table/m-p/1231216#M17821 2024-11-16T10:15:45Z Re: Pivot Table https://community.qlik.com/t5/Management-Governance/Pivot-Table/m-p/1231217#M17822 <HTML><HEAD></HEAD><BODY><P>Check this out!</P><P></P><P>Fei</P></BODY></HTML> Fri, 11 Nov 2016 03:49:23 GMT https://community.qlik.com/t5/Management-Governance/Pivot-Table/m-p/1231217#M17822 NZFei 2016-11-11T03:49:23Z