topic Re: Huge data export to CSV loses decimal precision issue in QlikView

Huge data export to CSV loses decimal precision issue

Wed, 25 Nov 2020 16:16:04 GMT

Hi Dears,

I have a straight table which may have over 70000 rows data.

And when I trigger function to export to excel, it will store as CSV format.

However, the question is, I set the number format to show 2 decimals in QV table which may have 8 decimals from datasource, when it goes to CSV file, loses decimal precision.

But, when I limit rows, maybe down to 20000, table will export as xls format and in full decimals.

I have attached the QV sample, please help me.

Thanks.

Re: Huge data export to CSV loses decimal precision issue

swuehl — Thu, 19 May 2016 09:49:50 GMT

Try to use an export to xlsx (edit: using a macro), which should be capable of handling more records.

Re: Huge data export to CSV loses decimal precision issue

Thu, 19 May 2016 10:07:03 GMT

Can we export in full decimals in CSV in system function in QV?

We are not allowed to use macro in dashboard in normal.

Re: Huge data export to CSV loses decimal precision issue

swuehl — Thu, 19 May 2016 10:08:30 GMT

Or maybe try to export the table in this sample.

Re: Huge data export to CSV loses decimal precision issue

Thu, 19 May 2016 10:14:09 GMT

thank you.

But we have over 30 expressions in a table like that, if each one I add a new column, it will double when user export it which is not so ideally.

And less than 65000, it works fine.

Can you have another solution.

Re: Huge data export to CSV loses decimal precision issue

swuehl — Thu, 19 May 2016 10:19:32 GMT

What about creating another table only for export?

Basically a copy of your original, with all number formats set to max precision.

Not the best idea from a usability point of view, but I have no idea how to change the CSV value format on export (without macros).