I have 8 lakhs or close to 1 million data to export from QlikView to Excel.
However, I tried to click on (XL) on the QlikView tables that i have created but it exports only 65,000 thousand or 3,00,000 lakhs data.
Can somebody help me how to export the huge data from qlikview to excel. Please.
I checked many post regarding this issue but none of them helped me to find the correct solution
... and what are you going to do with all that data once it is exported to XLS?
Maybe the answer to your actual problem does not include XLS.
Hi Vineeth Pujari,
Thanks for your advise in the first place however, I tried to find the above provided option (RowlimitforCsvinsteedofxls) in the setting but i did not get to see the similar kind of options could you please give some more additional information to find the suggested steps. Please
Excel i am using 2013 version
Here is what i found in settings tab.
HI Onno Van Knotsenburg,
Thanks for taking sometime to review my request.
I am trying to export the data from QlikView to Excel because to validate the data and the numbers what i am trying to display in Qlikview.
So kindly let me know if you have any idea as to how i can fix this issue.
I am using Heidi Sql tool to review/load/modify the data in that i am able to see 834000 data but in the qlikview i can see only 436000 data when it is exported to excel from tabels.
I am using Heidi Sql tool to review/load/modify the data in that i am able to see 834000 data but in the qlikview i can see only 436000 data when it is exported to excel from tables.
Go to Help >> About Qlikview >> Click on Qlikview logo to the left bottom ..
Just some thought's
1 : Are you loading all the data from your data source without any filters? I mean is there no where clause or Having clause??
2: Is the table a straight table with an expression, that is filtering out other rows as per the calculation?
2: Maybe you are running out of ram and Qlikview only dumped what rows it could process!!
If you only want to validate your results in Qlikview; query your data source to summarize the data and validate the summarized data with your Qlikview data table.
Working with a millions rows in Excel is the worst thing every.