Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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`
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)