Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ruben_moya
Contributor III
Contributor III

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.

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!

 
 
Labels (3)
2 Replies
dilipranjith
Partner
Partner

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
Contributor III
Contributor III
Author

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