Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

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

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.

6 Replies
ajaykumar1
Contributor III

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

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
Valued Contributor II

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

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.

MVP & Luminary
MVP & Luminary

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

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

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

Thankyou  Jagan Mohan

Highlighted
deepaktibhe
Valued Contributor

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

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

MVP & Luminary
MVP & Luminary

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

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.