Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

sreeni_qvd
New Contributor III

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
MVP
MVP

Re: How to see the data in excel

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

Re: How to see the data in excel

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

MVP
MVP

Re: How to see the data in excel

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.

Community Browser