Discussion Board for collaboration related to QlikView Deployment.
Hi, I have a data 1300000 (13 Lacks) in straight table, if export data into excel max it's showing 10Lacks records, how can i see the total records in excel, Please let me know
It is basically beacuse of excel row limit. Different versions of excel have different limits. Excel 2010 -...1,048,576. You can try with excel 2013 (though i am not sure about the limit there).
Here is the limitation of different versions of excel .Hope it helps you,
Excel 2007-2010 -> 1,048,576 rowsExcel '97-2003 -> 65,536 rowsExcel pre-'97 -> 16,384 rows
Thanks and Regards,
If you export to excel of straight table data, Qlikview splits into multiple sheets if rows exceeds Excel limit.
For example for Excel 97-2003, in Sheet1 it exports 65535 rows and remaining in the corresponding sheets. You can see the extra data in the next sheets.
Hope this helps you. Please find attached file.