topic HOW TO CALCULATE PERCENTAGE? in QlikView https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-PERCENTAGE/m-p/202519#M60185 <HTML><HEAD></HEAD><BODY><P>HI, Experts</P><P>i am facing problem while calculating percentage. i have two fields TOTAL_UNIT_PASSED AND TOTAL_UNITS_PROCESSED and i want to calculate the percentage (TOTAL_UNIT_PASSED/TOTAL_UNITS_PROCESSED *100). but i am getting result only 100 and how to aply % symbol.</P><P>Please help me.......</P><P></P><P>Thanks</P><P></P><P></P></BODY></HTML> Thu, 07 Apr 2011 10:04:54 GMT sushil353 2011-04-07T10:04:54Z HOW TO CALCULATE PERCENTAGE? https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-PERCENTAGE/m-p/202519#M60185 <HTML><HEAD></HEAD><BODY><P>HI, Experts</P><P>i am facing problem while calculating percentage. i have two fields TOTAL_UNIT_PASSED AND TOTAL_UNITS_PROCESSED and i want to calculate the percentage (TOTAL_UNIT_PASSED/TOTAL_UNITS_PROCESSED *100). but i am getting result only 100 and how to aply % symbol.</P><P>Please help me.......</P><P></P><P>Thanks</P><P></P><P></P></BODY></HTML> Thu, 07 Apr 2011 10:04:54 GMT https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-PERCENTAGE/m-p/202519#M60185 sushil353 2011-04-07T10:04:54Z HOW TO CALCULATE PERCENTAGE? https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-PERCENTAGE/m-p/202520#M60186 <HTML><HEAD></HEAD><BODY><P style="font-weight: bold">TOTAL_UNIT_PASSED / TOTAL_UNITS_PROCESSED &amp; ' %'<BR /></P><P>Use this expression and change the format in the <B>NUMBER</B> tab. Check the option <B>Show in Percentage%</B>.</P><P>Cheers - DV</P></BODY></HTML> Thu, 07 Apr 2011 10:08:25 GMT https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-PERCENTAGE/m-p/202520#M60186 IAMDV 2011-04-07T10:08:25Z HOW TO CALCULATE PERCENTAGE? https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-PERCENTAGE/m-p/202521#M60187 <HTML><HEAD></HEAD><BODY><P>you could use the following if it's a text box:</P><P style="font-weight: bold">NUM( TOTAL_UNIT_PASSED / TOTAL_UNITS_PROCESSED , '###.00%' )</P><P>you can decide if you want the decimals or not</P><P></P><P>Jon</P><P style="font-weight: bold"><BR /></P></BODY></HTML> Thu, 07 Apr 2011 10:31:48 GMT https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-PERCENTAGE/m-p/202521#M60187 2011-04-07T10:31:48Z HOW TO CALCULATE PERCENTAGE? https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-PERCENTAGE/m-p/202522#M60188 <HTML><HEAD></HEAD><BODY><P>THANKS JON</P><P></P><P></P></BODY></HTML> Thu, 07 Apr 2011 10:56:08 GMT https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-PERCENTAGE/m-p/202522#M60188 sushil353 2011-04-07T10:56:08Z HOW TO CALCULATE PERCENTAGE? https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-PERCENTAGE/m-p/202523#M60189 <HTML><HEAD></HEAD><BODY><P>Sushil - Please can you mark on answered on Jon's post.</P><P>Thanks,</P><P>DV</P></BODY></HTML> Thu, 07 Apr 2011 11:05:27 GMT https://community.qlik.com/t5/QlikView/HOW-TO-CALCULATE-PERCENTAGE/m-p/202523#M60189 IAMDV 2011-04-07T11:05:27Z