Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export to Excel

Hi,

I have a dashboard along with that I have export to excel button.

But when I click on the export to excel I am getting only 1000 records and I am missing another 400 records.

Is there any settings in the properties?

Thanks,

15 Replies
Not applicable
Author

Deepak, its just simple requirement.

I have 3 dashboards in my application. I would like take couple of fields from that dashboard and export the data into excel.

But when I export the data into excel using button its coming only 1000 records but as per the source file its having 1800 records.

thats it.

I did not get where I can find restricting the data into excel??

Thanks,

deepakk
Partner - Specialist III
Partner - Specialist III

Can you attach the application ?

Not applicable
Author

Hi,

As I said I am using excel source file and used one button to export the data in to the excel.

There are two options in Export Action settings:

1) Export to File : If I select this option I am getting all the records (Used some local location).

2) ClipBoard : If I select this option I am getting only 999 records excluding the field names.

My question is why we are getting only 999 records if my source file is having more than 1000 records??

pls find the attached qvw file.

Thanks,

Not applicable
Author

Hi Experts,

Has anyone got a chance to look in to this or any idea to solve it?

Thanks,

deepakk
Partner - Specialist III
Partner - Specialist III

hi,

This might be a bug. you can write it down to Qliktech for support.

Not applicable
Author

I did it, but no response from them.

Thanks,