topic Excel import in QlikView

Excel import

Mon, 29 Sep 2014 02:08:14 GMT

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

Re: Excel import

ecolomer — Mon, 29 Sep 2014 04:30:09 GMT

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

Re: Excel import

aveeeeeee7en — Mon, 29 Sep 2014 04:37:47 GMT

Go through this thread:

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

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

Regards

Av7eN

Re: Excel import

Mon, 29 Sep 2014 04:43:38 GMT

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

Re: Excel import

ashfaq_haseeb — Mon, 29 Sep 2014 06:25:38 GMT

Hi,

Can you post your script here?

Regards

ASHFAQ

Re: Excel import

sagarkharpude — Mon, 29 Sep 2014 06:54:47 GMT

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

Re: Excel import

Mon, 29 Sep 2014 07:04:48 GMT

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

Re: Excel import

Mon, 29 Sep 2014 07:16:00 GMT

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

Re: Excel import

Mon, 29 Sep 2014 07:23:25 GMT

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.