4 Replies Latest reply: Feb 11, 2014 9:24 AM by Friedrich Hofmann RSS

    How to find out when a DB_field is empty

    Friedrich Hofmann


      Hi,

       

      I have a problem loading data from a database - unfortunately it must remain somewhat theoretic because I have no direct access to that database, so I cannot see what the original data looks like. What I see in QlikView is this:

      - An SQL SELECT produces, among others, two fields: Item_Nr and Date

           - The ITEM_Nr is just a number;

           - The DATE has the format 'DD.MM.YYYY hh:mm:ss TT';

      => I have the impression that, in contrast to our other databases where the Date_field is always populated, in that one there are a nr. of items with no entry in the date_field.

      => I found out by bringing up two lists for ITEM and DATE, selecting all values of DATE and then right-clicking on ITEM and saying "select excluded records"

         => that would return me all the ITEMs with no entry in the field DATE associated, yes?

       

      - That, as I said, is in difference to the other (two) databases we have where every ITEM has a DATE associated.

      => That difference apparently is what leads to trouble lateron.

      (this is just a trial in a somewhat mirky data_problem we have)

       

      => My question is: How can I (in the script) find out whether/ when that date_field is blank? I have already tried the ISNULL(), ISNUM() and ISTEXT() functions, but they don't work

       

      Thanks a lot!

      Best regards,

       

      DataNibbler