2 Replies Latest reply: Dec 1, 2015 4:31 AM by Alisa Lorenz RSS

    Empty date in database - convert in QlikView

    Alisa Lorenz

      Hello everybody,

       

      I have the following problem: I get the data for the QlikView application through a SQL database. I made a table in QlikView where some information is shown, e.g. the Name of the product, how much it costs and a scheduled datum (see attached screenshot).

      Unfortunately, QlikView does not handle empty date fields in the SQL database and therefore shows the date 31.12.4294967295. I would like the fields in QlikView being empty, when no date is found in the database (e.g. like in the column "Güte": for "Schneidkosten" there is no "Güte" information and therefore the fields stay empty).

       

      I would appreciate any idea!

      Thanks, Alisa

       

      QlikView Tabelle Schneidkosten.JPG