Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I export data from a table to Excel?

I've a table which contains 13 columns and 7.343 rows. When I export this table to Excel all columns are transportet but only 7.279 rows show up in Excel.

I double checked on the source data the number of rows and also checked it in qlik. On the database and in the qlik table are 7.343 rows!

Could you please give me some hints what the issue could be?

All the best

Michael

5 Replies
shraddha_g
Partner - Master III
Partner - Master III

make sure 1. show zero value is checked in Add-ons section

2. Show null values is checked for all dimensions.

and then try exporting.

Not applicable
Author

yes, I checkt both things, show zero value is checked in Add-ons and for all dimensions show null values is checked

ift_isabelle
Partner - Creator III
Partner - Creator III

Have you tried this extension?

Qlik Branch

rittermd
Master
Master

If possible I would try to identify some rows that are missing and then see what they have in common.

I have not run into this issue before when exporting to Excel.

ogster1974
Partner - Master II
Partner - Master II

To troubleshoot your issue does your table have a key that uniquely identifies your rows?. If yes include in your table and then export to excel you should then see the gaps in your export which should suggest the reason for row exclusion.