topic Num formatting in App Development

Num formatting

ruben_moya — Sat, 16 Nov 2024 03:25:49 GMT

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!

Re: Num formatting

dplr-rn — Wed, 29 Jan 2020 15:27:51 GMT

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/

Re: Num formatting

ruben_moya — Wed, 29 Jan 2020 15:46:23 GMT

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