Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Honored Contributor III

Re: How can I export data from a table to Excel?

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

Re: How can I export data from a table to Excel?

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

ift_isabelle
Contributor II

Re: How can I export data from a table to Excel?

Have you tried this extension?

Qlik Branch

rittermd
Honored Contributor

Re: How can I export data from a table to Excel?

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
Honored Contributor II

Re: How can I export data from a table to Excel?

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.