topic Re: Empty date in database - convert in QlikView in QlikView

Empty date in database - convert in QlikView

Thu, 26 Nov 2015 09:07:25 GMT

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

Re: Empty date in database - convert in QlikView

tamilarasu — Thu, 26 Nov 2015 10:29:24 GMT

Hi Alisa,

Something like below,

ALT(DATE#( Date,'DD-MM-YYYY' ),'Not valid' )

Let me know.

Re: Empty date in database - convert in QlikView

Tue, 01 Dec 2015 09:31:19 GMT

Hello Tamil,

Thanks for your quick answer! Your suggestion was kind of "right", but it didn't work because of the database. Apparently there is some update which is responsible for this problem, otherwise it would have worked. I am working on this now with our IT-guys.

Anyway, I appreciate your help!