topic How to display data in the mentioned format in Pivot Table? Very Urgent.. in QlikView https://community.qlik.com/t5/QlikView/How-to-display-data-in-the-mentioned-format-in-Pivot-Table-Very/m-p/23818#M767748 <HTML><HEAD></HEAD><BODY><P>Dear All I have two dimensions ZONE &amp; VARIETY and 4 expressions (EXP1,EXP2,EXP3,EXP4) for each Zones.</P><P>I want to display Variety &amp; Zone wise sum of all expressions in the below format...</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EAST&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WEST&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NORTH&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SOUTH</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4</SPAN></SPAN></SPAN></P><P>Variey</P><P>TOTAL&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4 </SPAN></SPAN></SPAN></SPAN></P><P></P><P></P><P>but I am not able to display the data in above mentioned format.</P><P>I am only able to display in the below mentioned format....................</P><P></P><P>Variety&nbsp;&nbsp; Zone&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4</SPAN></P><P><SPAN style="font-size: 13.3333px;">V1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EAST</SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">V1</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WEST</SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">V1</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NORTH</SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">V1</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SOUTH</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TOTAL&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4</SPAN><BR /></SPAN></P><P></P><P></P><P>Note : V1 is the name of Variety which exist in all Zones.</P><P></P><P>Please help me to display data in the above mentioned format in Pivot Table.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT anilkumarmishra 2020-11-25T16:16:04Z How to display data in the mentioned format in Pivot Table? Very Urgent.. https://community.qlik.com/t5/QlikView/How-to-display-data-in-the-mentioned-format-in-Pivot-Table-Very/m-p/23818#M767748 <HTML><HEAD></HEAD><BODY><P>Dear All I have two dimensions ZONE &amp; VARIETY and 4 expressions (EXP1,EXP2,EXP3,EXP4) for each Zones.</P><P>I want to display Variety &amp; Zone wise sum of all expressions in the below format...</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EAST&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WEST&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NORTH&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SOUTH</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4</SPAN></SPAN></SPAN></P><P>Variey</P><P>TOTAL&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4 </SPAN></SPAN></SPAN></SPAN></P><P></P><P></P><P>but I am not able to display the data in above mentioned format.</P><P>I am only able to display in the below mentioned format....................</P><P></P><P>Variety&nbsp;&nbsp; Zone&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4</SPAN></P><P><SPAN style="font-size: 13.3333px;">V1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EAST</SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">V1</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WEST</SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">V1</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NORTH</SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">V1</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SOUTH</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TOTAL&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">EXP1&nbsp;&nbsp;&nbsp; EXP2&nbsp; EXP3&nbsp; EXP4</SPAN><BR /></SPAN></P><P></P><P></P><P>Note : V1 is the name of Variety which exist in all Zones.</P><P></P><P>Please help me to display data in the above mentioned format in Pivot Table.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-display-data-in-the-mentioned-format-in-Pivot-Table-Very/m-p/23818#M767748 anilkumarmishra 2020-11-25T16:16:04Z Re: How to display data in the mentioned format in Pivot Table? Very Urgent.. https://community.qlik.com/t5/QlikView/How-to-display-data-in-the-mentioned-format-in-Pivot-Table-Very/m-p/23819#M767749 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><BR />You can move your dimensions by drag and drop. Here you can find a video with the explicacion. The example is in the 6:30 min :</P><P></P><P><A href="https://www.youtube.com/watch?v=x0-38NZiXS0" title="https://www.youtube.com/watch?v=x0-38NZiXS0">QlikView | Pivot Tables - YouTube</A></P></BODY></HTML> Thu, 14 Jun 2018 07:26:04 GMT https://community.qlik.com/t5/QlikView/How-to-display-data-in-the-mentioned-format-in-Pivot-Table-Very/m-p/23819#M767749 jaumecf23 2018-06-14T07:26:04Z