topic Re: Data format changed after downing data from visualization to excel file in App Development

Data format changed after downing data from visualization to excel file

vincentma — Mon, 20 Dec 2021 21:05:46 GMT

We have a AGE column in a table, but after download the data from the table to excel file, the format of the data was changed to Currency, which looks very strange. Is there any setting for download data format? Thanks!

Re: Data format changed after downing data from visualization to excel file

Ksrinivasan — Fri, 22 Jan 2021 02:54:48 GMT

hi,

use this syntax

Num(round(Field1,0.01), '# ##0,00 '

ksrinivasan

Re: Data format changed after downing data from visualization to excel file

vincentma — Fri, 22 Jan 2021 06:01:10 GMT

This need to add by field level in every APP, we have many APPs, is there a site level setting? Or is it a bug of Nov 2020 version? It happened after I upgrade Qlik Sense from Nov 2019 to Nov 2020.