topic Number format error in QlikView https://community.qlik.com/t5/QlikView/Number-format-error/m-p/363536#M135220 <HTML><HEAD></HEAD><BODY><P>Okay, I need help. When percent is checked, it's taking a fixed number such as 94.27, and making it 9427%.</P><P></P><P>Please note the Format 'Preview' in each image.</P><P>Please note the only difference between these images is my choosing 'Show in Percent (%)' on the bottom image.</P><P></P><P>Thank you,</P><P></P><P><IMG alt="variance.jpg" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/12300_variance.jpg" width="450" /></P><P></P><P><IMG alt="variance2.jpg" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/12308_variance2.jpg" width="450" /></P></BODY></HTML> Wed, 21 Mar 2012 21:56:46 GMT 2012-03-21T21:56:46Z Number format error https://community.qlik.com/t5/QlikView/Number-format-error/m-p/363536#M135220 <HTML><HEAD></HEAD><BODY><P>Okay, I need help. When percent is checked, it's taking a fixed number such as 94.27, and making it 9427%.</P><P></P><P>Please note the Format 'Preview' in each image.</P><P>Please note the only difference between these images is my choosing 'Show in Percent (%)' on the bottom image.</P><P></P><P>Thank you,</P><P></P><P><IMG alt="variance.jpg" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/12300_variance.jpg" width="450" /></P><P></P><P><IMG alt="variance2.jpg" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/12308_variance2.jpg" width="450" /></P></BODY></HTML> Wed, 21 Mar 2012 21:56:46 GMT https://community.qlik.com/t5/QlikView/Number-format-error/m-p/363536#M135220 2012-03-21T21:56:46Z Number format error https://community.qlik.com/t5/QlikView/Number-format-error/m-p/363537#M135221 <HTML><HEAD></HEAD><BODY><P>I assume that you want to display 94,27 as 94,27%. Well, checking the "Show in percent" will not just add a percentsign, but it will also multiply by 100 (since 1.0 is 100%). You should probably just divide the expression you have now with 100.</P><P></P><P>/HIC</P></BODY></HTML> Wed, 21 Mar 2012 22:16:03 GMT https://community.qlik.com/t5/QlikView/Number-format-error/m-p/363537#M135221 hic 2012-03-21T22:16:03Z Number format error https://community.qlik.com/t5/QlikView/Number-format-error/m-p/363538#M135222 <HTML><HEAD></HEAD><BODY><P>Henric, thank you!</P></BODY></HTML> Wed, 21 Mar 2012 22:30:14 GMT https://community.qlik.com/t5/QlikView/Number-format-error/m-p/363538#M135222 2012-03-21T22:30:14Z