topic Re: Slow export to Excel in QlikView

Slow export to Excel

Mon, 15 Oct 2012 08:15:56 GMT

Hi,

When i try to export data from a chart to an Excel file, it takes 30 minutes for 10,000 rows! it is bothering the users and it should be much much faster.

We use QlikView 11 SP1, and Excel 2010.

Does anyone know how we can make the export faster?

Thanks,

Guy D.

Re: Slow export to Excel

thomas_skariah — Mon, 15 Oct 2012 08:44:37 GMT

Try to export the chart in text or csv and then open the file through excel.

Regards,

Tom

Re: Slow export to Excel

Mon, 15 Oct 2012 09:13:18 GMT

Hi Tom,

It seems to take the same as exporting it to Excel...

Re: Slow export to Excel

thomas_skariah — Mon, 15 Oct 2012 13:27:17 GMT

Yup,but as you said it takes a longer time when directly exporting to excel.

so,try to export in txt and then open the file in excel.

Regrads,

Tom

Re: Slow export to Excel

Thu, 18 Oct 2012 17:07:47 GMT

Hi,

I found out what is the cause of the problem:

It is becuase the chart columns may be hide \ shown according to Condition expression. (using the Conditional checkbox in the Expressions tab), and therefore the export takes a lot of time (comparing to "regular" chart, without the condition feature ).

Thanks a lot,

Guy

Re: Slow export to Excel

Jason_Michaelides — Tue, 23 Oct 2012 13:06:04 GMT

Guy,

Don't accept this as the way it should be. I raised this issue with QlikTech and received a patch that fixed it.

http://community.qlik.com/message/271454#271454

Hope this helps,

Jason

Re: Slow export to Excel

Thu, 25 Oct 2012 09:57:07 GMT

Hoping the patches will arrive soon ... Thanks!

Re: Slow export to Excel

Thu, 25 Oct 2012 13:00:35 GMT

To anybody:

Here are the Patches to fix the problem:

After having reviewed your request we would suggest the following solution:

Here is the link to the patch that you are looking for:
64-bit Server MSP

http://d1cf4w4kkla6tb.cloudfront.net/Customer%20Builds/11.00/11419/_MSI/_MSP/QlikView%20Server%20Patch%20X64/Patch/QlikView%20Server%20Patch%20X64.11419.exe

32-bit Desktop MSP

http://d1cf4w4kkla6tb.cloudfront.net/Customer%20Builds/11.00/11419/_MSI/_MSP/QlikView%20Patch%20X86/Patch/QlikView%20Patch%20X86.11419.exe

64-bit Desktop MSP

http://d1cf4w4kkla6tb.cloudfront.net/Customer%20Builds/11.00/11419/_MSI/_MSP/QlikView%20Patch%20X64/Patch/QlikView%20Patch%20X64.11419.exe