topic Re: Decimal Point Increaing if we export to Excel in QlikView

Decimal Point Increaing if we export to Excel

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a line chart, where Value is showing in two decimal.

However when I am exporting this to Excel the decimal points are increasing in Excel.

Could anyone please help me to solve this.

I am attaching the sample qvw file.

Thanks,

Sarif

Re: Decimal Point Increaing if we export to Excel

niclaz79 — Wed, 30 May 2018 08:51:51 GMT

Hi,

The fact that you are only showing two decimal points in your graph is not the same as the value only having two decimal points. The graph rounds it to what has been set in the 'number' tab, however the raw data remains the same and that is what is being exported.

If you want to ensure that the values only have two decimal points at all times, you should adjust this in the script using the num() function with '# ##0,00' as input.

Re: Decimal Point Increaing if we export to Excel

jaumecf23 — Wed, 30 May 2018 08:59:49 GMT

Hi,

Attached a new version. Try if now the application is having a correct behaviour.

Thanks,

Re: Decimal Point Increaing if we export to Excel

mhmmd_srf — Wed, 30 May 2018 09:12:50 GMT

Awsome...thank you so much...