topic Test object to Percentage in QlikView https://community.qlik.com/t5/QlikView/Test-object-to-Percentage/m-p/1198517#M386300 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">This is my expression <SPAN style="font-size: 13.3333px;">=num($(vShipcurrentOnTimeAmtPct),'#,##0%')</SPAN></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">this is the result 75,018,045%</SPAN></P><P></P><P>I would like to see just 75.0% instead on whole number </P><P></P><P>Can some body help</P><P></P><P>Thanks,</P><P>Dinesh </P></BODY></HTML> Fri, 14 Oct 2016 20:41:11 GMT dseelam 2016-10-14T20:41:11Z Test object to Percentage https://community.qlik.com/t5/QlikView/Test-object-to-Percentage/m-p/1198517#M386300 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">This is my expression <SPAN style="font-size: 13.3333px;">=num($(vShipcurrentOnTimeAmtPct),'#,##0%')</SPAN></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">this is the result 75,018,045%</SPAN></P><P></P><P>I would like to see just 75.0% instead on whole number </P><P></P><P>Can some body help</P><P></P><P>Thanks,</P><P>Dinesh </P></BODY></HTML> Fri, 14 Oct 2016 20:41:11 GMT https://community.qlik.com/t5/QlikView/Test-object-to-Percentage/m-p/1198517#M386300 dseelam 2016-10-14T20:41:11Z Re: Test object to Percentage https://community.qlik.com/t5/QlikView/Test-object-to-Percentage/m-p/1198518#M386301 <HTML><HEAD></HEAD><BODY><P>Not sure why you get that, but may be divide it by 1000,000,000</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"><STRONG>=Num($(vShipcurrentOnTimeAmtPct)<SPAN style="color: #ff0000;">/1000000000</SPAN>,'#,##0%')</STRONG></SPAN></P></BODY></HTML> Fri, 14 Oct 2016 20:44:05 GMT https://community.qlik.com/t5/QlikView/Test-object-to-Percentage/m-p/1198518#M386301 sunny_talwar 2016-10-14T20:44:05Z Re: Test object to Percentage https://community.qlik.com/t5/QlikView/Test-object-to-Percentage/m-p/1198519#M386302 <HTML><HEAD></HEAD><BODY><P>Seems likely you're calculating % incorrectly in the variable, in which case fix the calculation, and it will be formatted correctly.</P></BODY></HTML> Fri, 14 Oct 2016 23:59:21 GMT https://community.qlik.com/t5/QlikView/Test-object-to-Percentage/m-p/1198519#M386302 johnw 2016-10-14T23:59:21Z