Download option in qliksense saas saves all xslx columns as string

[miran1]

Hey,

When user clicks on a Download button on the table and exports the data as xslx, all data gets saved as a string.

Is there a way to save certain columns as numbers / dates?

These columns have correct datatypes in the models.

Thanks,

Miran

[Eugene_Sleator]

Hi @miran1 when you check the data in the Data Model Viewer do you see the TAGS as being "$numeric" or "$numberic$integer ". I have just tested and the data in my test was populated to the xslx file as numeric values not strings. 

[miran1]

Hey @Eugene_Sleator,

Thanks for the reply!

`Amount` field is `$numeric` and `Date` field is `$numeric $integer $ascii $text`.

Date field is originally iso8601, which qlik doesn't support it seems

`Date(Date#(Replace(Replace("Date", 'T', ' '), 'Z', ''), 'YYYY-MM-DD hh:mm:ss.fff')) AS Receipt_Date`

and Amount field

`Num#(Amount) AS Receipt_Amount`

[miran1]

I just made a small test, where i exported three columns.

First one being the raw `Receipt_Date`,

second a custom master item, based on the above raw field

and third being the raw `Receipt_Amount`.

Using the `TYPE` function in excel i got 1 (number) for the first column and 2 (text) for second and third.

(more on the TYPE function https://support.microsoft.com/en-us/office/type-function-45b4e688-4bc3-48b3-a105-ffa892995899)