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.
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!
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
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