topic Truncate numeric expression in QlikView https://community.qlik.com/t5/QlikView/Truncate-numeric-expression/m-p/212818#M66692 <HTML><HEAD></HEAD><BODY><P>I have a chart that has an expression. Currently the number format is set to Fixed to 2 Decimals. This rounding to 2 decimals is causing some problems when looking at the data. Something that evaluates to 0.9995 is being displayed as 1.0. What I would like to do is leave it displayed in the chart as 0.99. I looked for some kind of truncate function but am unable to find anything. Is there a way to truncate this expression in the chart to 2 decimal places?</P><P>Thanks.</P></BODY></HTML> Sat, 10 Oct 2009 03:39:25 GMT 2009-10-10T03:39:25Z Truncate numeric expression https://community.qlik.com/t5/QlikView/Truncate-numeric-expression/m-p/212818#M66692 <HTML><HEAD></HEAD><BODY><P>I have a chart that has an expression. Currently the number format is set to Fixed to 2 Decimals. This rounding to 2 decimals is causing some problems when looking at the data. Something that evaluates to 0.9995 is being displayed as 1.0. What I would like to do is leave it displayed in the chart as 0.99. I looked for some kind of truncate function but am unable to find anything. Is there a way to truncate this expression in the chart to 2 decimal places?</P><P>Thanks.</P></BODY></HTML> Sat, 10 Oct 2009 03:39:25 GMT https://community.qlik.com/t5/QlikView/Truncate-numeric-expression/m-p/212818#M66692 2009-10-10T03:39:25Z Truncate numeric expression https://community.qlik.com/t5/QlikView/Truncate-numeric-expression/m-p/212819#M66693 <HTML><HEAD></HEAD><BODY><P>Floor will truncate decimals as you like</P></BODY></HTML> Sat, 10 Oct 2009 03:58:34 GMT https://community.qlik.com/t5/QlikView/Truncate-numeric-expression/m-p/212819#M66693 2009-10-10T03:58:34Z Truncate numeric expression https://community.qlik.com/t5/QlikView/Truncate-numeric-expression/m-p/212820#M66694 <HTML><HEAD></HEAD><BODY><P>Thanks. I knew there had to be a way to do this.</P></BODY></HTML> Mon, 12 Oct 2009 22:24:44 GMT https://community.qlik.com/t5/QlikView/Truncate-numeric-expression/m-p/212820#M66694 2009-10-12T22:24:44Z