Export to excel Decimal point issue

Mahamed_Qlik — Sat, 29 Jul 2017 18:26:03 GMT

Hi All,

Issue -

Export to excel from straight table, the values are showing one decimal in excel is correct, but if I select the value in excel it is showing in 4 decimal.

Qlikview straight table :

Now after exporting to excel using upper right corner, I am getting the same result but if you can see, when I select 1.1 valuse in excel then it is shwoing as 1.13984, so it should be 1.1, this is what I am execting

Note-

- Dont suggest to create export button and to write macro, it is not required.

- I have tried to change the number format in Number tab #,##0.0

- I have use NUm fucntion with expression to show as result in #,##0.0

Kindly provide the solution.

Best Regards,

Mahamed

Re: Export to excel Decimal point issue

antoniotiman — Sat, 29 Jul 2017 18:49:46 GMT

HiMahamed,

use Round(YourExpression,0.1)

Regards,

Antonio

topic Re: Export to excel Decimal point issue in QlikView

Export to excel Decimal point issue

Re: Export to excel Decimal point issue