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: 
Not applicable

how to load 75000 records from excel to qlikview script at a time and what is the limit of excel records in qlikview

Hiiii,

Could any one help me to find the solution for this question .

Thanks in advance.

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

There is no limitation in Qlikview to load records from Excel file, you can load as many rows as excel supports in a sheet, we usually loads lakhs of records.

Regards,

Jagan.

View solution in original post

6 Replies
ajaykumar1
Creator III
Creator III

Hi,

As per mine; Excel supports around 10 lacks and that all records qv will support.one way For loading the 75000 records apply debug with 75000 records.(Its one way and so many ways are there.I guess).

Regards,

Ajay

salto
Specialist II
Specialist II

Hi Koripalli,

          Importing an Excel sheet is pretty straightforward in QlikView. This thread can help you : Excel data import

     Regarding the limit you ask about, it will be probably more related to Excel (as far as I know, previous versions of Excel had a limit in the number of rows per sheet). I don't think there is a predefined limit in Qlik for Excel.

     Hth.

jagan
Luminary Alumni
Luminary Alumni

Hi,

There is no limitation in Qlikview to load records from Excel file, you can load as many rows as excel supports in a sheet, we usually loads lakhs of records.

Regards,

Jagan.

Not applicable
Author

Thankyou  Jagan Mohan

deepakqlikview_123
Specialist
Specialist

Hi Koripalli,

I do not think so there is any limit.Better way you can first of all create QVD for Excel table and use that QVD for your further work.

Thanks

jagan
Luminary Alumni
Luminary Alumni

Hi,

There is no limitation for whatever the source Excel, CSV, XML, Database etc. in Qlikview, you can load millions of records.

If you got the answer please close this thread by giving Correct and Helpful answers to the post.

Regards,

Jagan.