topic Re: Exporting or Send to Excel huge data in QlikView

Exporting or Send to Excel huge data

Wed, 25 Nov 2020 16:16:04 GMT

Hello Experts,

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

Thank You,

Vinay

Re: Exporting or Send to Excel huge data

oknotsen — Thu, 21 Jul 2016 11:31:27 GMT

... 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.

Re: Exporting or Send to Excel huge data

settu_periasamy — Thu, 21 Jul 2016 18:46:49 GMT

Instead on 'Send to Excel' option , you can try with Export option with .CSV format.

Re: Exporting or Send to Excel huge data

vinieme12 — Thu, 21 Jul 2016 18:53:45 GMT

what is this setting set to? also what version of excel are you using?

Re: Exporting or Send to Excel huge data

maheshkuttappa — Thu, 21 Jul 2016 18:58:57 GMT

You can save the file using

STORE tablename into tablename.csv(txt)

But I agree with Onno van Knotsenburg comment

Re: Exporting or Send to Excel huge data

Mon, 25 Jul 2016 06:15:58 GMT

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.

Thank You,

Vinay

Re: Exporting or Send to Excel huge data

Mon, 25 Jul 2016 06:25:26 GMT

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.

Re: Exporting or Send to Excel huge data

Mon, 25 Jul 2016 06:26:37 GMT

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.

Re: Exporting or Send to Excel huge data

Mon, 25 Jul 2016 06:42:59 GMT

Thanks for your update but its the same issue...Nothing change....

Re: Exporting or Send to Excel huge data

vinieme12 — Mon, 25 Jul 2016 08:27:42 GMT

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.

Re: Exporting or Send to Excel huge data

oknotsen — Thu, 28 Jul 2016 08:25:19 GMT

For validation, you don't need this ridiculously large number of rows. What you do is create some test data that meets your use cases and you load those. That way you can check if your calculations work.

Ask your customer some bogus records that contain the numbers you need to check and what they should end up as.

It is software. If it does the calculation correct for the first record, it will also do so for the million records after that.

Re: Exporting or Send to Excel huge data

Mon, 01 Aug 2016 07:29:08 GMT

Hi Vineeth Pujari,

Sorry for the delay response.

To answer your questions.

1)No i am not. only few fields i am loading on the QV table.

2)The table is Pivot table and its has filtering expressions

3) Nope. No problem with RAM that perfectly alright

Well, I believe i found the issue because when i add/load all the fields to the table on QlikView it get the maximum data exported. But when I just load few columns export the data it will do partially.

Thanks a lot for your kind help

Re: Exporting or Send to Excel huge data

Mon, 01 Aug 2016 07:29:57 GMT

I believe i found the issue because when i add/load all the fields to the table on QlikView it get the maximum data exported. But when I just load few columns export the data it will do partially.

Thanks a lot for your kind help

Re: Exporting or Send to Excel huge data

beck_bakytbek — Mon, 01 Aug 2016 09:01:49 GMT

Hi Vinay,

readr this issue: *** 6 Weeks in to QV Development, 30 Million Records QV Document and Help Needed!!! ****

i suggest this issue can solve your Problem

i hope that helps

beck

Re: Exporting or Send to Excel huge data

pedromsouza — Fri, 02 Mar 2018 11:07:54 GMT

It works for Qlikview Desktop only, right? Where is this variable stored for Qlikview Server?

Re: Exporting or Send to Excel huge data

buzzy996 — Fri, 02 Mar 2018 11:28:29 GMT

upgrade ur ms office tool kit to version 2013 or 2016,it allows to export upto 10lakhs approximate.

Re: Exporting or Send to Excel huge data

pedromsouza — Fri, 02 Mar 2018 11:29:55 GMT

You mean the MS Office installed in Qlikview Server?

Re: Exporting or Send to Excel huge data

buzzy996 — Fri, 02 Mar 2018 11:32:34 GMT

yes

Re: Exporting or Send to Excel huge data

pedromsouza — Fri, 02 Mar 2018 11:56:22 GMT

Thanks! I'll look into it.