topic Re: How to get % in a column in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/How-to-get-in-a-column-in-Pivot-Table/m-p/1237681#M393464 <HTML><HEAD></HEAD><BODY><P>Awesome!! Close the thread by marking the correct response.</P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Wed, 08 Feb 2017 16:17:43 GMT sunny_talwar 2017-02-08T16:17:43Z How to get % in a column in Pivot Table https://community.qlik.com/t5/QlikView/How-to-get-in-a-column-in-Pivot-Table/m-p/1237678#M393461 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am attaching a application in which i want year wise % of a product Types.</P><P></P><P>like given below</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="163.4" style="width: 549.4px; height: 167.4px;" width="547.4"><TBODY><TR><TD class="xl63" height="17" width="59">Year</TD><TD class="xl64" style="border-left: none;" width="62">2014-15</TD><TD class="xl64" style="border-left: none;" width="51">2014-15</TD><TD class="xl64" style="border-left: none;" width="62">2015-16</TD><TD class="xl64" style="border-left: none;" width="51">2015-16</TD><TD class="xl64" style="border-left: none;" width="62">2016-17</TD><TD class="xl64" style="border-left: none;" width="51">2016-17</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Type</TD><TD class="xl65" style="border-top: none; border-left: none;">Total_Sales</TD><TD class="xl65" style="border-top: none; border-left: none;">% Linked</TD><TD class="xl65" style="border-top: none; border-left: none;">Total_Sales</TD><TD class="xl65" style="border-top: none; border-left: none;">% Linked</TD><TD class="xl65" style="border-top: none; border-left: none;">Total_Sales</TD><TD class="xl65" style="border-top: none; border-left: none;">% Linked</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Linked</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">37.50%</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">40.00%</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">7</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">58.33%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">Non Linked</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">62.50%</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">60.00%</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">41.67%</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">Total</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">8</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">10</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">12</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR></TBODY></TABLE><P></P><P>please help to get the desired out-put.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 08 Feb 2017 16:01:32 GMT https://community.qlik.com/t5/QlikView/How-to-get-in-a-column-in-Pivot-Table/m-p/1237678#M393461 pra_kale 2017-02-08T16:01:32Z Re: How to get % in a column in Pivot Table https://community.qlik.com/t5/QlikView/How-to-get-in-a-column-in-Pivot-Table/m-p/1237679#M393462 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Count(Policy)/Count(TOTAL &lt;Year&gt; Policy)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/152458_Capture.PNG" style="height: 94px; width: 620px;" /></P></BODY></HTML> Wed, 08 Feb 2017 16:05:27 GMT https://community.qlik.com/t5/QlikView/How-to-get-in-a-column-in-Pivot-Table/m-p/1237679#M393462 sunny_talwar 2017-02-08T16:05:27Z Re: How to get % in a column in Pivot Table https://community.qlik.com/t5/QlikView/How-to-get-in-a-column-in-Pivot-Table/m-p/1237680#M393463 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Thanks Sunny it is working.</P></BODY></HTML> Wed, 08 Feb 2017 16:16:40 GMT https://community.qlik.com/t5/QlikView/How-to-get-in-a-column-in-Pivot-Table/m-p/1237680#M393463 pra_kale 2017-02-08T16:16:40Z Re: How to get % in a column in Pivot Table https://community.qlik.com/t5/QlikView/How-to-get-in-a-column-in-Pivot-Table/m-p/1237681#M393464 <HTML><HEAD></HEAD><BODY><P>Awesome!! Close the thread by marking the correct response.</P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Wed, 08 Feb 2017 16:17:43 GMT https://community.qlik.com/t5/QlikView/How-to-get-in-a-column-in-Pivot-Table/m-p/1237681#M393464 sunny_talwar 2017-02-08T16:17:43Z