Discussion Board for collaboration related to QlikView App Development.
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.
Try to use an export to xlsx (edit: using a macro), which should be capable of handling more records.
Can we export in full decimals in CSV in system function in QV?
We are not allowed to use macro in dashboard in normal.
Or maybe try to export the table in this sample.
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.
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).