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).
Server as JDBCDSMonitorServer,
Runtime as JDBCDSMonitorRuntime,
Failures as JDBCDSMonitorFailures,
Waiting as JDBCDSMonitorWaiting,
State as JDBCDSMonitorState
(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!