topic Re: Help With Date in QlikView

Help With Date

prees959 — Sun, 24 Sep 2017 09:56:18 GMT

Hi,

I am joining two tables, TableA and TableB, and need to create a single date for all records. This data field also needs to join onto my master calendar:

Im trying to use this expression:

if(IsNull(DateA),date(DateB,'DD/MM/YYYY'),DateA) as DATE,

But this doesn't link to my master calendar

But if I just use ;

DateA as DATE

Then these only those records from Table A link to my master calendar.

Can anyone advise please?

Phil.

Re: Help With Date

swuehl — Sun, 24 Sep 2017 10:01:16 GMT

Is DateB maybe a timestamp?

Then use

if(IsNull(DateA),date(floor(DateB),'DD/MM/YYYY'),DateA) as DATE,

Re: Help With Date

prees959 — Sun, 24 Sep 2017 10:11:03 GMT

Perfect Thank you!