2 Replies Latest reply: Mar 22, 2016 12:40 PM by Gonçalo Bernardino RSS

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

    Gonçalo Bernardino

      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!