Export to excel limit in AJAX

[#1]

Hi Qlikviewer,

We have users experiencing error : <result><message text="Session lost" /><restart/></result> when export to the excel spreadsheet  because the data is more than 65,000 records. Our users are using Ajax to access to the dashboard. I I made the following adjustments in the server but I'm still getting the error : <result><message text="Session lost" /><restart/></result> and no data in is exported.

Change the following config file.

..\QlikTech\WebServer\config.xml

----------------------------------------------------
  <QvsTimeout>1800</QvsTimeout>
  <SessionCookieTimeOut>1800</SessionCookieTimeOut>

setting.ini file

RowLimitForCsvLinsteadofXls = 200000

The location of setting.ini file should be C:\ProgramData\QlikTech\QlikViewServer\

Thank you very much!

Jasmine

[#2]

Hi Pablo,

Can you provide the link to where you found this issue/bug listed in the knowledge base ?

Thanks.

Rachel

[pablolabbe]

Hi Rachel,

  I found this note in the release notes document of version 11.0 sr2:

  48736 "Export to excel causes QlikView to become unresponsive (hangs) ".

  Maybe could be your case.

Best Regards,

Pablo

[Anonymous]

Hi Martin,

can you provide more information about this please?  what is it and an example how you would use it - if possible?

Thanks,

John.

[simondachstr]

Have a look at Action -> External -> Export -> Setup.

Note, however, that the exported data is not aggregated.

[#6]

Create a duplicate chart and have a show condition on them both one Count(RowNo())<66000 and the other Count(RowNo())>66000 on the chart with <66000 enable the export to excel button on the other one turn it off.

The only true way to stop exporting is via server and that is defined by user/usergroup