topic Re: Excel Decimal values in QlikView https://community.qlik.com/t5/QlikView/Excel-Decimal-values/m-p/1252630#M396259 <HTML><HEAD></HEAD><BODY><P>Use Round function while using expression..something like below</P><P></P><P>Round(SUM(Sales),'0.01') </P><P>or</P><P>Round(SUM(Sales),'0.1')</P></BODY></HTML> Thu, 23 Feb 2017 09:23:00 GMT MK_QSL 2017-02-23T09:23:00Z Excel Decimal values https://community.qlik.com/t5/QlikView/Excel-Decimal-values/m-p/1252629#M396258 <HTML><HEAD></HEAD><BODY><P>I have a Sales value as 20.123456 in DB. In the report we are displaying in the Bar graph and it is rounded off to 1 decimals. Hence it is displayed as 20.1</P><P>When the Bar Graph is exported to excel, the value displayed in the cell as 20.1.</P><P>But when clicked on the cell,the value is displayed as 20.1234561018. It is displaying extra values after 5th or 6th digits(1018) which is not available in the db.</P><P>Can anyone help why the extra numbers are coming in the excel after specified decimal places.?</P><P>Is there any option to fix this.?</P></BODY></HTML> Thu, 23 Feb 2017 09:06:07 GMT https://community.qlik.com/t5/QlikView/Excel-Decimal-values/m-p/1252629#M396258 mohamedafzal 2017-02-23T09:06:07Z Re: Excel Decimal values https://community.qlik.com/t5/QlikView/Excel-Decimal-values/m-p/1252630#M396259 <HTML><HEAD></HEAD><BODY><P>Use Round function while using expression..something like below</P><P></P><P>Round(SUM(Sales),'0.01') </P><P>or</P><P>Round(SUM(Sales),'0.1')</P></BODY></HTML> Thu, 23 Feb 2017 09:23:00 GMT https://community.qlik.com/t5/QlikView/Excel-Decimal-values/m-p/1252630#M396259 MK_QSL 2017-02-23T09:23:00Z Re: Excel Decimal values https://community.qlik.com/t5/QlikView/Excel-Decimal-values/m-p/1252631#M396260 <HTML><HEAD></HEAD><BODY><P>Thanks Manish.</P><P>It worked...</P></BODY></HTML> Thu, 23 Feb 2017 10:29:38 GMT https://community.qlik.com/t5/QlikView/Excel-Decimal-values/m-p/1252631#M396260 mohamedafzal 2017-02-23T10:29:38Z