4 Replies Latest reply: Jul 21, 2014 6:24 AM by Friedrich Hofmann RSS

    One more question on SQL code

    Friedrich Hofmann

      Hi,

       

      I would jsut like to ask:

      Is this a valid SQL_statement in Qlikview?

      >>> WHERE   END_TIME <= Time(Frac(Now()), 'hh:mm')  <<

      (I want to load from a database table all records from today (there is another filter for that) and up to the ReloadTime (I could alternatively place it in the preceding LOAD, but it would be more elegant to just not load any unwanted records from the database instead of dropping them afterwards.

      Also, as the report is supposed to run every 10min, keeping the SQL_SELECT to the absolute minimum is crucial.

      Thanks a lot!

       

      Best regards,

       

      DataNibbler