Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
yes, I checkt both things, show zero value is checked in Add-ons and for all dimensions show null values is checked
Have you tried this extension?
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.
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.