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: 
sreeni_qvd
Creator
Creator

How to see the data in excel

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

3 Replies
tresesco
MVP
MVP

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).

Not applicable

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

jagan
Luminary Alumni
Luminary Alumni

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.