topic Re: Send to Excel - Table with Conditional Show - Very Slow in QlikView

topic Re: Send to Excel - Table with Conditional Show - Very Slow in QlikView https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415893#M154667 <HTML><HEAD></HEAD><BODY><P>Thanks Jason.</P><P></P><P>If you don't mind, I will close this thread and will follow progress on your posting so as not to duplicate postings on the same problem.</P><P></P><P>Clifford</P></BODY></HTML> Mon, 15 Oct 2012 15:41:58 GMT 2012-10-15T15:41:58Z Send to Excel - Table with Conditional Show - Very Slow https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415889#M154663 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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. </P><P></P><P>Has anyone else experienced the same problem and is this due to the use of the "Enable Condition" option in the object?</P><P></P><P>Currently using V11 SR2.</P></BODY></HTML> Mon, 15 Oct 2012 14:20:25 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415889#M154663 2012-10-15T14:20:25Z Re: Send to Excel - Table with Conditional Show - Very Slow https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415890#M154664 <HTML><HEAD></HEAD><BODY><P>I am having exactly the same issue with the same version (although I also saw it in SR1) - see my post here - <A _jive_internal="true" class="loading" href="https://community.qlik.com/message/267809#267809">http://community.qlik.com/message/267809#267809</A></P><P></P><P>I think I will report it to QT support as it may be a bug.</P><P></P><P>Jason</P></BODY></HTML> Mon, 15 Oct 2012 15:11:52 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415890#M154664 Jason_Michaelides 2012-10-15T15:11:52Z Re: Send to Excel - Table with Conditional Show - Very Slow https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415891#M154665 <HTML><HEAD></HEAD><BODY><P>Thanks Jason.</P><P></P><P>If you don't mind, I will close this thread and will follow progress on your posting so as not to duplicate postings on the same problem.</P><P></P><P>Clifford</P></BODY></HTML> Mon, 15 Oct 2012 15:41:47 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415891#M154665 2012-10-15T15:41:47Z Re: Send to Excel - Table with Conditional Show - Very Slow https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415892#M154666 <HTML><HEAD></HEAD><BODY><P>Thanks Jason.</P><P></P><P>If you don't mind, I will close this thread and will follow progress on your posting so as not to duplicate postings on the same problem.</P><P></P><P>Clifford</P></BODY></HTML> Mon, 15 Oct 2012 15:41:53 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415892#M154666 2012-10-15T15:41:53Z Re: Send to Excel - Table with Conditional Show - Very Slow https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415893#M154667 <HTML><HEAD></HEAD><BODY><P>Thanks Jason.</P><P></P><P>If you don't mind, I will close this thread and will follow progress on your posting so as not to duplicate postings on the same problem.</P><P></P><P>Clifford</P></BODY></HTML> Mon, 15 Oct 2012 15:41:58 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415893#M154667 2012-10-15T15:41:58Z Re: Send to Excel - Table with Conditional Show - Very Slow https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415894#M154668 <HTML><HEAD></HEAD><BODY><P>Thanks Jason.</P><P></P><P>If you don't mind, I will close this thread and will follow progress on your posting so as not to duplicate postings on the same problem.</P><P></P><P>Clifford</P></BODY></HTML> Mon, 15 Oct 2012 15:42:04 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415894#M154668 2012-10-15T15:42:04Z Re: Send to Excel - Table with Conditional Show - Very Slow https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415895#M154669 <HTML><HEAD></HEAD><BODY><P>Thanks Jason.</P><P></P><P>If you don't mind, I will close this thread and will follow progress on your posting so as not to duplicate postings on the same problem.</P><P></P><P>Clifford</P></BODY></HTML> Mon, 15 Oct 2012 15:42:13 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415895#M154669 2012-10-15T15:42:13Z Re: Send to Excel - Table with Conditional Show - Very Slow https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415896#M154670 <HTML><HEAD></HEAD><BODY><P>Thanks Jason.</P><P></P><P>If you don't mind, I will close this thread and will follow progress on your posting so as not to duplicate postings on the same problem.</P><P></P><P>Clifford</P></BODY></HTML> Mon, 15 Oct 2012 15:42:17 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415896#M154670 2012-10-15T15:42:17Z Re: Send to Excel - Table with Conditional Show - Very Slow https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415897#M154671 <HTML><HEAD></HEAD><BODY><P>Thanks Jason.</P><P></P><P>If you don't mind, I will close this thread and will follow progress on your posting so as not to duplicate postings on the same problem.</P><P></P><P>Clifford</P></BODY></HTML> Mon, 15 Oct 2012 15:42:23 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415897#M154671 2012-10-15T15:42:23Z Re: Send to Excel - Table with Conditional Show - Very Slow https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415898#M154672 <HTML><HEAD></HEAD><BODY><P>Thanks Jason.</P><P></P><P>If you don't mind, I will close this thread and will follow progress on your posting so as not to duplicate postings on the same problem.</P><P></P><P>Clifford</P></BODY></HTML> Mon, 15 Oct 2012 15:42:27 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415898#M154672 2012-10-15T15:42:27Z Re: Send to Excel - Table with Conditional Show - Very Slow https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415899#M154673 <HTML><HEAD></HEAD><BODY><P>I don't mind at all, although you only have to do it once! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" />  I have just raised it with QT support and will update back to my original post - <A _jive_internal="true" class="loading" href="https://community.qlik.com/message/267809#267809" title="http://community.qlik.com/message/267809#267809">http://community.qlik.com/message/267809#267809</A>, so subscribe there!</P><P></P><P>Jason</P></BODY></HTML> Mon, 15 Oct 2012 15:45:33 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415899#M154673 Jason_Michaelides 2012-10-15T15:45:33Z Re: Send to Excel - Table with Conditional Show - Very Slow https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415900#M154674 <HTML><HEAD></HEAD><BODY><P>Sorted with a customer patch - </P><P></P><P><A _jive_internal="true" class="loading active_link" href="https://community.qlik.com/message/271454#271454">http://community.qlik.com/message/271454#271454</A></P><P></P><P>Jason</P></BODY></HTML> Tue, 23 Oct 2012 13:11:02 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415900#M154674 Jason_Michaelides 2012-10-23T13:11:02Z Re: Send to Excel - Table with Conditional Show - Very Slow https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415901#M154675 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Wed, 16 Jan 2013 06:36:23 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415901#M154675 nayanpatel 2013-01-16T06:36:23Z Re: Send to Excel - Table with Conditional Show - Very Slow https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415902#M154676 <HTML><HEAD></HEAD><BODY><P>I got this working with a customer patch - see my post <A _jive_internal="true" class="active_link loading" href="https://community.qlik.com/message/271454#271454">http://community.qlik.com/message/271454#271454</A></P><P></P><P>QT also believe this is fixed in SR2 Update 2 so you might try applying that.</P></BODY></HTML> Wed, 16 Jan 2013 08:16:24 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel-Table-with-Conditional-Show-Very-Slow/m-p/415902#M154676 Jason_Michaelides 2013-01-16T08:16:24Z