Slow export to Excel

[#1]

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.

[thomas_skariah]

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

Regards,

Tom

[#3]

Hi Tom,

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

[thomas_skariah]

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

[#5]

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

[Jason_Michaelides · Accepted solution]

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

[#7]

Hoping the patches will arrive soon ... Thanks!

[#8]

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%20Pat...


32-bit Desktop MSP

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


64-bit Desktop MSP

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