topic Exporting table in excel with Auto formatting in App Development

Exporting table in excel with Auto formatting

ruben_moya — Sat, 16 Nov 2024 03:26:11 GMT

(QlikSense)

Dear experts,

We need to change the format number in a measure in a tables . We are using a variable ( v.FNum) and the num function to control it. We define the variable in the script and we give them different values depending on certain conditions:

SET v.FNum = '#.##0';

SET v.FNum = '#,##0';

num(Sum({<Product={'Hotel'}>}Sales),v.FNum)

It works perfectly.

HOWEVER, to be able use the format we need to define the formatting field as 'Auto'. Qlik doesn't seem to be able to export the format when the formatting isn't defined as Number. If the format is defined as Number, it's not dynamic anymore.

Could you think of a way of controlling the formatting of a measure and being able to keep the formatting in excel after having exported it?

Thanks in advanced!

Re: Exporting table in excel with Auto formatting

UserID2626 — Thu, 30 Jan 2020 13:09:53 GMT

try changing formatting from Auto to custom and enter your format

Re: Exporting table in excel with Auto formatting

ruben_moya — Thu, 30 Jan 2020 14:27:57 GMT

Thanks for your anwer! however, if i use that format its not dynamic anymore

Re: Exporting table in excel with Auto formatting

UserID2626 — Fri, 31 Jan 2020 04:04:39 GMT

Can you share the screenshot what exactly you want to export(how the data should be)

Re: Exporting table in excel with Auto formatting

ruben_moya — Fri, 31 Jan 2020 07:49:52 GMT

Just a table with a sum(sales) measure and a dimension.

Find a screenshot attached. On the right is how it is shown in Qlik and on the left how it is actually exported

Re: Exporting table in excel with Auto formatting

UserID2626 — Fri, 31 Jan 2020 08:45:02 GMT

I am getting correct result when exporting from my Qlik desktop, kindly check number format options in your Excel.