Send to Excel - Table with Conditional Show - Very Slow

[#1]

A data extract tab has been created for users to be able to specify the dimensions/expressions required in a pivot table. The pivot table uses the "Enable Condition" option to show/hide the specified dimensions/expressions.

Users then click on the "Send to Excel" icon to export the data. The use of the "Enable Condition" in the object appears to have caused a very slow response in exporting the data. What used to take seconds/minutes is now taking a lot longer, sometimes up to 30 minutes. The problem also exists when the Export option and saving the output as .csv or .xls is used.

Has anyone else experienced the same problem and is this due to the use of the "Enable Condition" option in the object?

Currently using V11 SR2.

[Jason_Michaelides]

I don't mind at all, although you only have to do it once!   I have just raised it with QT support and will update back to my original post - http://community.qlik.com/message/267809#267809, so subscribe there!

Jason

[Jason_Michaelides]

Sorted with a customer patch -

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

Jason

[nayanpatel]

I have the same problem here Qlikview 11.0 SR2 not able to export excel or takes 30 minutes or more which can be exported in seconds in Qlikview 9.0

[Jason_Michaelides]

I got this working with a customer patch - see my post http://community.qlik.com/message/271454#271454

QT also believe this is fixed in SR2 Update 2 so you might try applying that.