Already restarted the services before, strangely after moving the value higher I get the save as dialogue appear quicker than before.
I've used set analysis to split up the report into chunks and this works (but I then have to combine all the outputs in excel). However one section is still large and this is not exporting as a result!
Will have a think and may have to split it up by grouping the data together in chunks (say 50K rows against the columns of 78) but not an elegant solution. Also going to log this as a bug with QT.
Actually I didn't find the exact solution for this, I was also facing same problem. I was unable to export more than 65,000 data to excel on access point but able to export on locally.
For that I did right click on chart and click on export option and save it to .csv/ .excel format where it first ask for location where to save the file.
The issue is that sometimes when we click send to Excel, even though we get the pop-up that it's extracting the data, after 5/6 minutes it downloads an empty file to the browser with the following message:
We have checked in the server C:\ProgramData\QlikTech\QlikViewServer\Temp folder and we can see that it creates a file with the correct data but for some reason it's unable to downloaded it from the browser client.
We are suspicious that it could be related to the filesize - around 100MB+
