Query showing a result like 0 when the site is down or not responding

Question

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).

LOAD
Server  as JDBCDSMonitorServer, 
Runtime  as JDBCDSMonitorRuntime, 
Failures  as JDBCDSMonitorFailures,
Waiting  as JDBCDSMonitorWaiting,
State  as JDBCDSMonitorState
FROM
"http://url"
(html, codepage is 1252, embedded labels)
;

How should I have the query showing a result like 0 when the site is down or not responding? Many thanks for the help!

In this case I'm using Qlikview to fetch data from a url site. It loads the columns from the url and then prompts the results. — Malbordio, Mar 22 '16 at 13:00
a_horse_with_no_name thanks for the heads up, I just changed subject and tag. — Malbordio, Mar 22 '16 at 13:01

score 0 · Accepted Answer · answered Mar 22 '16 at 20:27

0

Found the solution. I just need to add in the code the following:

I added the following in the initial code and it works.

SET ErrorMode = '0';

answered Mar 22 '16 at 20:27

Malbordio

92
3
4
20

Query showing a result like 0 when the site is down or not responding

1 Answers1