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