Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
leonard_palacio
New Contributor II

Export Data Qlik Sense - Data Truncated

We're doing an implementation on a client with Qlik Sense, and they need to generate a report based on a table. The object is a simple table and must be exported based on selections (filters) given by generating export data to Excel, said that the data has been truncated, and the table is not exported with the full data off an alert at the time of export where it says that the data has been truncated

It has been consulted in the community and informs an extension that works and exports all the records in csv, but is not functional when you select (filter) so this solution is not feasible performed.

Also on the Help of Qlik Sense on the web talking about a method called ExportData but I have not managed correctly set or not if that is the solution.

Your cooperation in this area is essential for the complete customer information when generating reports from Qlik Sense.

Thanks...

3 Replies
Employee
Employee

Re: Export Data Qlik Sense - Data Truncated

I'm not really sure what you are asking for here but yes, there is a limit on 1 000 000 rows for Excel exports and 5 000 000 for CSV exports. After that the data will be truncated, the Qlik Sense client is not a ETL tool so I would really question the use case if you need to export more data than that from your analytical tool.

leonard_palacio
New Contributor II

Re: Export Data Qlik Sense - Data Truncated

Yes, i need export more data using qlik sense. Other Question is about the limit 1000000 rows or 5000000 csv, how i do to export file type csv? And this report have 200000 rows but only export near 55000 why? Other information is this report have 17 columns, is important this when will be to export?

Employee
Employee

Re: Export Data Qlik Sense - Data Truncated

Hello Leonard, I replied to your other message in another post as well. As Alex has stated there are certain limits on exporting data. I don't see a way to export to csv from the standard "export data" menu item. XLS is the only option I see. When exporting the data, are you sure that there aren't any filters selected? The exports respect the filtered values.

let us know

Regards,

Mike T

Qlik

Regards,
Mike Tarallo
Qlik
Community Browser