How to make it as blank if source field like "01/01/0001"

[saivina2920]

I am receiving date field as "01/01/0001" from source database (Oracle).

But, we don't want to maintain this field in Qlikview Report. If we are receiving like "01/01/0001" then we need to format the field as blank.

my current LOAD statement below.

LOAD Date(Floor([EMP_JOIN_DATE]), 'DD/MM/YYYY') as [EMP_JOIN_DATE]

How to check the condition here if "01/01/0001" and make it as blank..

[MayilVahanan]

HI @saivina2920 

Try like below

LOAD If(Right([EMP_JOIN_DATE] ,4)<>'0001', Date(Floor([EMP_JOIN_DATE]), 'DD/MM/YYYY')) as [EMP_JOIN_DATE]

[saivina2920]

Thanks.

It's working in List Box or individual displaying. When mapping with Table list, again it's showing "01/01/0001".

what is the problem...

[settu_periasamy · Accepted solution]

May be try this..

Map_Date_Blank:
Mapping
LOAD
Text(Date(MakeDate(01,1,01),'DD/MM/YYYY')) as Date
,'' as Blank
AutoGenerate 1;

MAP [EMP_JOIN_DATE] using Map_Date_Blank;

LOAD
Date(Floor([EMP_JOIN_DATE]), 'DD/MM/YYYY') as [EMP_JOIN_DATE]
From Table;