Excel import

[#1]

Hello,

I have a problem in the Excel Importation. QlikView retains only the 100 firsts lines of the Excel Table.

Does anyone ever had this problem?

Thank you for your answer

[ecolomer]

See in the load menu. You can select option to load only 100 records

[aveeeeeee7en]

Hi

Go through this thread:

http://community.qlik.com/thread/87057  // See jagan Answer

http://community.qlik.com/thread/30256

Regards

Av7eN

[#4]

Hi BenjaminBuder As per my understanding in the table view only 100 records will be shown, but Qlikview imports the complete data. So create a straight table and you can see the complete data. Regards, Manish Virmani

[ashfaq_haseeb]

Hi,

Can you post your script here?

Regards

ASHFAQ

[sagarkharpude]

You will not able to see the complete data in table view.Create a simple table box/straight table  and then see the complete data.

Sagar Kharpude

[#7]

Thank you in a simple table i can see the complete data. But why it's not able table view?

[#8]

Hi It is behavior of the view table, only top 100 records will be shown. MV

[#9]

Table View is just to give us an idea about what table structure is and what kind of values each column is storing. A complete data set view will never be a requirement and recommended technique for any tool.