Num formatting

[ruben_moya]

Dear experts,

I'm having problems trying to export a table to excel.

Does anyone know if there is any way of controlling the format of the App. 

If I change the following variables, I get the expected result.

SET ThousandSep=',';
SET DecimalSep='.';

However, when I export the table, the number format changes.

Any idea how to face this problem? I just need to control the format of the exported file, depending on the user.

1

SET ThousandSep=',';
SET DecimalSep='.';

2

SET ThousandSep='.';
SET DecimalSep=',';

Find attached a picture where I show the difference between the table in Qlik and the exported in Excel

Thanks for your time!

[dplr-rn]

the pictures are not visbile.

but i am assuming your source data format is the one which appears in the excel.

i would recommend changing the format for the numbers in the script. using num()

if there are a big number of columns use touch less formatting

https://qlikviewcookbook.com/2016/07/touchless-formatting/

[ruben_moya]

The problem is that so as to be able to see in the table the measure correctly, I need to change de formatting to AUTO. If I change it to AUTO, Qlik doesn't export the format correctly. So I can't use the Num() function