topic Loading a Spreadsheet - Testing Before Loading in QlikView

Loading a Spreadsheet - Testing Before Loading

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

I'm loading a spreadsheet on a station outside the server, and I want for testing the connection between the server and the station before the load statement to be performed. This will be done to prevent an error. The idea is: If the connection is active, the load is performed, else the load statement is jumped, and the rest of the script continues How can I do that?

Thanks a lot !!!

Giovane

Re: Loading a Spreadsheet - Testing Before Loading

MindaugasBacius — Sat, 27 Oct 2018 18:31:20 GMT

I think this is exactly what you wish:

SET ErrorMode=0;

CONNECTION STATEMENT

SET ErrorMode=1;

It simply ignores the errors that occurs on connection statement and moves on to the rest of the script.

I suggest you reading more about ErrorMode and ScriptError variables:

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ErrorVariables/ErrorMode.htm

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ErrorVariables/ScriptError.htm

Re: Loading a Spreadsheet - Testing Before Loading

Giovane — Sat, 27 Oct 2018 23:11:28 GMT

Thank you, Mindaugas...you got it right. Problem solved !!!

Thanks a lot.

Giovane