topic Re: Exports a chart to Excel with a large data volume in QlikView

Exports a chart to Excel with a large data volume

pgdavis2 — Mon, 26 Jan 2026 18:19:17 GMT

When a user exports a chart to Excel with a large data volume, it can lock up the system if there is too much data.

Is there a way to kill such a task to free up system resources?

Using QV11 Server

Re: Exports a chart to Excel with a large data volume

Bill_Britt — Thu, 11 Oct 2012 19:49:36 GMT

Hi pgdavis2,

There is not way to do this other that stopping QVS and then all users would lose connection.

Bill

Re: Exports a chart to Excel with a large data volume

pgdavis2 — Thu, 11 Oct 2012 20:07:11 GMT

Thanks for confirming - that's what I thought from our research on it.

Is there a good way to limit the export to a certain # of records? For example I would like the system to warn the user if they try to export more than 50k rows and prevent them from doing it.

Re: Exports a chart to Excel with a large data volume

Bill_Britt — Thu, 11 Oct 2012 20:26:22 GMT

Hi pgdavis2,

I don't know of a way to do that. Unless you tried to do something with a macro.

Bill

Re: Exports a chart to Excel with a large data volume

pgdavis2 — Thu, 11 Oct 2012 20:28:49 GMT

Thanks Bill. I've seen a few macros aimed at this but that's a last resort with Ajax...I shy away from them.

Re: Exports a chart to Excel with a large data volume

Thu, 18 Oct 2012 07:49:34 GMT

Hello

maybe is better to let users export huge amount to csv - not xls.

I am not tested this parameter:

[Settings 7]

RowLimitForCsvInsteadOfXls=65500

in server settings ?

Do you have MS Excell installed on server or only viever ?

Re: Exports a chart to Excel with a large data volume

Bill_Britt — Thu, 18 Oct 2012 13:09:49 GMT

Hugo,

I sent him that information off line and you are correct this does help and setting the number below 65K will even speed it up on smaller jobs. However, the problem is with large amount of data the connection times out before the data can be pushed to the user.

In talking to out development group they have confirm that this is wroking as designed and it was never meant for large data sets.

Bill