Skip to main content
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
Showing results for 
Search instead for 
Did you mean: 

Num formatting

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.


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


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!

Labels (3)
2 Replies
Partner - Master III
Partner - Master III

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