topic Re: Need help in converting percentage into value in QlikView https://community.qlik.com/t5/QlikView/Need-help-in-converting-percentage-into-value/m-p/1395059#M1325069 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>1 option</P><P><IMG alt="POR.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/181779_POR.png" style="height: 503px; width: 620px;" /></P></BODY></HTML> Wed, 01 Nov 2017 21:54:49 GMT el_aprendiz111 2017-11-01T21:54:49Z Need help in converting percentage into value https://community.qlik.com/t5/QlikView/Need-help-in-converting-percentage-into-value/m-p/1395057#M1325062 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need some help in the percentage value. Basically I have created a table in Qlikview which has an expression which calculate percentage and I want an expression which gives the value of that percentage. For example if the percentage is 69% and I want an expression which gives value of 69% in another column.</P><P></P><P>Below is the example table which I've created and the expressions which I'm using to get the percentage value.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="81" style="width: 630px; height: 81px;"><TBODY><TR><TD height="17" style="border-width: 0.5pt 0px; border-style: solid none; border-color: black #960000; background-color: #e1e1e1;" width="161"><STRONG style="color: #960000;">Technology</STRONG></TD><TD style="border-width: 0.5pt 0px; border-style: solid none; border-color: black #960000; background-color: #e1e1e1;" width="95"><STRONG style="color: #960000;">Total Devices</STRONG></TD><TD style="border-width: 0.5pt 0px; border-style: solid none; border-color: black #960000; background-color: #e1e1e1;" width="137"><STRONG style="color: #960000;">Total Scannable Devices</STRONG></TD><TD style="border-width: 0.5pt 0px; border-style: solid none; border-color: black #960000; background-color: #e1e1e1;" width="77"><STRONG style="color: #960000;">% Coverage</STRONG></TD></TR><TR><TD height="17" style="border: 0px teal; border-image: none; background-color: white;"><STRONG style="color: #008080;">Desktop</STRONG></TD><TD style="border: 0px black; border-image: none; background-color: white;"><STRONG style="color: #000000;">368,964</STRONG></TD><TD style="border: 0px black; border-image: none; background-color: whitesmoke;"><STRONG style="color: #000000;">253,757</STRONG></TD><TD style="border: 0px black; border-image: none; background-color: white;"><STRONG style="color: #000000;">69%</STRONG></TD></TR></TBODY></TABLE><P></P><P></P><P>As you can see from the above example for the technology desktop the percentage is 69% and I want the expression to convert 69% to the number or value in another column as Coverage Value. Below is the expression which I'm using to get the % Coverage.</P><P></P><P>% Coverage Expression : count(<SPAN style="color: #960000;"><STRONG>Total Scannable Devices</STRONG></SPAN>)/count(<SPAN style="color: #960000;"><STRONG>Total Devices</STRONG></SPAN>)</P><P>Total Devices Expression: count(distinct columnname)</P><P></P><P>Total Scannable Devices Expression: count(distinct if(Columnname='Scanned',Columnname))</P><P></P><P>Regards,</P><P>Bharath Vikas</P><P></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Need-help-in-converting-percentage-into-value/m-p/1395057#M1325062 vikasshana 2026-01-26T18:19:17Z Re: Need help in converting percentage into value https://community.qlik.com/t5/QlikView/Need-help-in-converting-percentage-into-value/m-p/1395058#M1325066 <HTML><HEAD></HEAD><BODY><P>What you mean by number or value? What value you are looking to get there. 69% of Total devices scanned is 253,757, is this the value you are looking for?</P></BODY></HTML> Wed, 01 Nov 2017 21:34:59 GMT https://community.qlik.com/t5/QlikView/Need-help-in-converting-percentage-into-value/m-p/1395058#M1325066 vishsaggi 2017-11-01T21:34:59Z Re: Need help in converting percentage into value https://community.qlik.com/t5/QlikView/Need-help-in-converting-percentage-into-value/m-p/1395059#M1325069 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>1 option</P><P><IMG alt="POR.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/181779_POR.png" style="height: 503px; width: 620px;" /></P></BODY></HTML> Wed, 01 Nov 2017 21:54:49 GMT https://community.qlik.com/t5/QlikView/Need-help-in-converting-percentage-into-value/m-p/1395059#M1325069 el_aprendiz111 2017-11-01T21:54:49Z