Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Slow export to Excel from a chart with Conditional expressions

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

1 Solution

Accepted Solutions
Jason_Michaelides
Partner - Master II
Partner - Master II

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

View solution in original post

14 Replies
whiteline
Master II
Master II

Hi.

What version of QV11 do you use ?

Not applicable
Author

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

Not applicable
Author

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

Jason_Michaelides
Partner - Master II
Partner - Master II

Sorted for us with a customer patch.

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

Not applicable
Author

Thank You!

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

Jason_Michaelides
Partner - Master II
Partner - Master II

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

Not applicable
Author

Hi,

Is it a Desktop Patch?

Thanks,

Jason_Michaelides
Partner - Master II
Partner - Master II

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

Not applicable
Author

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