topic Re: Slow export to Excel from a chart with Conditional expressions in QlikView

Slow export to Excel from a chart with Conditional expressions

Thu, 18 Oct 2012 16:41:19 GMT

Hi,

I try to export data from a chart that its columns may be hide \ shown according to Condition expression. (using the Conditional checkbox in the Expressions tab)

This export takes a lot of time (comparing to "regular" chart, without the condition feature ).

Does anybody have any idea how to solve this issue ?

Thanks,

Guy

Re: Slow export to Excel from a chart with Conditional expressions

whiteline — Thu, 18 Oct 2012 17:11:12 GMT

Hi.

What version of QV11 do you use ?

Re: Slow export to Excel from a chart with Conditional expressions

Fri, 19 Oct 2012 20:40:29 GMT

Hi,

SP2 (i think the Service Pack upgrade dosn't help solving the problem. Only when i disable the Condtionanl expressions in the chart, the problem goes away).

Re: Slow export to Excel from a chart with Conditional expressions

Tue, 23 Oct 2012 08:40:25 GMT

Hi,

A walk around solution could be coping the chart, and disabled the Conditional Expressions functionality (so all the metrics appear). This chart will be used for export to excel purpose.

By using this copied chart, it solves the slowness issue. You can minimize it, so it will be used only when intending to export it to Excel.

Thanks,

Guy

Re: Slow export to Excel from a chart with Conditional expressions

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

Sorted for us with a customer patch.

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

Re: Slow export to Excel from a chart with Conditional expressions

Wed, 24 Oct 2012 15:09:44 GMT

Thank You!

I will contact QlikTech to get these patches. Is there any way to have it trhough the QlikView Site?

Re: Slow export to Excel from a chart with Conditional expressions

Jason_Michaelides — Wed, 24 Oct 2012 15:25:57 GMT

I doubt it as it is a patch not a formal release.

Re: Slow export to Excel from a chart with Conditional expressions

Thu, 25 Oct 2012 07:47:31 GMT

Hi,

Is it a Desktop Patch?

Thanks,

Re: Slow export to Excel from a chart with Conditional expressions

Jason_Michaelides — Thu, 25 Oct 2012 07:48:41 GMT

There are 3 versions of the patch that I know of. 32-bit and 64-bit desktop, and 64-bit server.

Re: Slow export to Excel from a chart with Conditional expressions

Thu, 25 Oct 2012 09:53:21 GMT

Thanks, I sent a request for them to QlikView Tech Support.

Re: Slow export to Excel from a chart with Conditional expressions

Thu, 25 Oct 2012 13:06:50 GMT

Here are they the patches from QlikTech Support:

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

Re: Slow export to Excel from a chart with Conditional expressions

Thu, 25 Oct 2012 20:04:50 GMT

Last question, just to be on the safe side:

do i just excute the .exe files, or sould i before stop the QV services (or unisntall QlikView app).

Thanks

Re: Slow export to Excel from a chart with Conditional expressions

Jason_Michaelides — Fri, 26 Oct 2012 07:05:48 GMT

Just execute the files. The installation will give you the option to stop the services or have a reboot at the end.

It all went smoothly for me but I say again this is a patch, not a formal release so be careful and test it first! I think that's why QT have not made it publicly available.

Re: Slow export to Excel from a chart with Conditional expressions

Sat, 27 Oct 2012 08:14:17 GMT

Thanks a lot! It works fine, the problem was solved.

Re: Slow export to Excel from a chart with Conditional expressions

Jason_Michaelides — Sat, 27 Oct 2012 18:24:36 GMT

Cool - made one hell of a difference for us!