Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
Hi,
Here is the limitation of different versions of excel .Hope it helps you,
Excel 2007-2010 -> 1,048,576 rows
Excel '97-2003 -> 65,536 rows
Excel pre-'97 -> 16,384 rows
Thanks and Regards,
S.Amuthabharathi
Hi,
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.
Regards,
Jagan.