Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Huge data export to CSV loses decimal precision issue

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.

1.jpg

2.png

I have attached the QV sample, please help me.

Thanks.

5 Replies
swuehl
MVP
MVP

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

Not applicable
Author

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

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

swuehl
MVP
MVP

Or maybe try to export the table in this sample.

Not applicable
Author

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.

swuehl
MVP
MVP

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).