topic Re: how to get column level percentage in QlikView https://community.qlik.com/t5/QlikView/how-to-get-column-level-percentage/m-p/1124657#M370328 <HTML><HEAD></HEAD><BODY><P>In expression use:</P><P>=Column(1)/Column(5)</P><P><SPAN style="font-size: 13.3333px;">=Column(2)/Column(5)</SPAN></P><P><SPAN style="font-size: 13.3333px;">and move on.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">In Number sheet set:</SPAN></P><P><SPAN style="font-size: 13.3333px;"><IMG __jive_id="125415" alt="Screenshot_1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125415_Screenshot_1.jpg" style="height: auto;" /><BR /></SPAN></P></BODY></HTML> Mon, 23 May 2016 13:34:07 GMT MindaugasBacius 2016-05-23T13:34:07Z how to get column level percentage https://community.qlik.com/t5/QlikView/how-to-get-column-level-percentage/m-p/1124656#M370327 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>My Data Looks like</P><P></P><P>A&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp; C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total&nbsp; %a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; %b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; %c&nbsp;&nbsp;&nbsp;&nbsp; %d</P><P>10&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp; 40&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp; =10/100&nbsp;&nbsp; =20/100&nbsp; =30/100&nbsp; =40/100</P><P></P><P>Could you help how to get the precntage part </P></BODY></HTML> Mon, 23 May 2016 11:51:18 GMT https://community.qlik.com/t5/QlikView/how-to-get-column-level-percentage/m-p/1124656#M370327 2016-05-23T11:51:18Z Re: how to get column level percentage https://community.qlik.com/t5/QlikView/how-to-get-column-level-percentage/m-p/1124657#M370328 <HTML><HEAD></HEAD><BODY><P>In expression use:</P><P>=Column(1)/Column(5)</P><P><SPAN style="font-size: 13.3333px;">=Column(2)/Column(5)</SPAN></P><P><SPAN style="font-size: 13.3333px;">and move on.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">In Number sheet set:</SPAN></P><P><SPAN style="font-size: 13.3333px;"><IMG __jive_id="125415" alt="Screenshot_1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125415_Screenshot_1.jpg" style="height: auto;" /><BR /></SPAN></P></BODY></HTML> Mon, 23 May 2016 13:34:07 GMT https://community.qlik.com/t5/QlikView/how-to-get-column-level-percentage/m-p/1124657#M370328 MindaugasBacius 2016-05-23T13:34:07Z Re: how to get column level percentage https://community.qlik.com/t5/QlikView/how-to-get-column-level-percentage/m-p/1124658#M370329 <HTML><HEAD></HEAD><BODY><P>You can try like this:</P><P></P><P><STRONG>A/RangeSum(A, B, C, D)</STRONG></P><P></P><P><STRONG>B<SPAN style="font-size: 13.3333px;">/RangeSum(A, B, C, D)</SPAN></STRONG></P><P></P><P><STRONG>C<SPAN style="font-size: 13.3333px;">/RangeSum(A, B, C, D)</SPAN></STRONG></P><P></P><P><STRONG>D</STRONG><SPAN style="font-size: 13.3333px;"><STRONG>/RangeSum(A, B, C, D)</STRONG></SPAN></P></BODY></HTML> Mon, 23 May 2016 13:37:01 GMT https://community.qlik.com/t5/QlikView/how-to-get-column-level-percentage/m-p/1124658#M370329 sunny_talwar 2016-05-23T13:37:01Z