Query showing a result like 0 when the site is down or not responding
I have the following query loaded in Qlikview that returns results from a website (works fine) but I want to display a result when, for example, the site is down or not responding (something like else or if null).
Re: Query showing a result like 0 when the site is down or not responding
Maybe you can set the ErrorMode to zero in your script before accessing the remote server, then check for ScriptErrorCount directly after your LOAD. If an error occured, branch into some error handling like creating zero values for your fields or whatever you want.
See the HELP for the error system variables or e.g.