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

[Colin-Albert]

One option could be to add a calculation condition to hide the chart until users have made selections that give fewer than N rows.

Obviously this prevents users exporting all data, which may be what you want.

[#3]

Hi Colin,

Thank you for your feedback. we want the user to access to all data in the dashboard.

Jasmine

[jerrysvensson]

Can any user export to Excel?

[pablolabbe]

Can you export all rows when using plug-in or when using desktop connected to Server ?

[#6]

I'm able to export data from my desktop version. Not sure about plug-in as I'm not using plug-in. But it is not working in Ajax.

Jasmine

[simondachstr]

Try using Export trigger (for raw data only). This has worked remarkably fast for me (Exporting 70MB Excel file in just a few seconds.

[pablolabbe]

His Jasmine,

   I found this issue listed as a bug in the Knowledge Base. What is your Qlikview version ?

[#9]

My version is 11.00.11282.0 SR1 64-bit Edition.

[#10]

How do you trigger this? I just learned that Macro is limited in AJAX.

Jasmine