Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hiiii,
Could any one help me to find the solution for this question .
Thanks in advance.
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.
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
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.
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.
Thankyou Jagan Mohan
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
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.