topic Change blank entries from database in QlikView

Change blank entries from database

Anonymous — Wed, 29 Sep 2010 11:15:34 GMT

Hi,

this is a part of my script:

MitgliedArb:

SQL SELECT AbmeldeDatum

FROM "CRM".dbo.MitgliedArb;

The field "AbmeldeDatum" is in the database partially empty.

These blank entries should be changed into a date like "01.01.2500".

Can someone help me ?

sunil2288 — Wed, 29 Sep 2010 11:36:48 GMT

HI Dirk

You can write

if(value(Abmeldedatum=' ',value(Abmeldedatum)='01-01-2500',value(Abmeldedatum)) as Abmeldedatum

Regards

Sunil

Wed, 29 Sep 2010 11:54:01 GMT

In the script main page


SET NULLDISPLAY=<01.01.2500>;

jonathandienst — Wed, 29 Sep 2010 12:12:50 GMT

On SQL Server:

SQL SELECT COALESCE(AbmeldeDatum,CONVERT(datetime, '01.01.2500', 104)) AS AbmeldeDatum

FROM "CRM".dbo.MitgliedArb;

Jonathan

Wed, 29 Sep 2010 12:13:52 GMT

Please write this script.

if(trim(len(AbmeldeDatum))=0,'null',AbmeldeDatum) as AbmeldeDatum

Regards

Ashish

Anonymous — Wed, 29 Sep 2010 13:33:42 GMT

Thank you all.

I use the solution from Ashish Srivastava.

The other proposals also work´s.