topic Date difference in two tables in QlikView

Date difference in two tables

bobbydave — Wed, 25 Nov 2020 16:16:04 GMT

Table1:

Load

INCIDENT_DATE

From...

Table2:

Load

BIRTHDATE

From....

I can use an expression to say INTERVAL(BIRTHDATE-INCIDENT_DATE, 'YY')

However, I am wondering how I do this in the script?

Wed, 27 Jul 2016 16:57:07 GMT

do you can make direcly...but you tables need stay thogether...

example

load

INCIDENT_DATE,

BIRTHDATE,

BIRTHDATE-INCIDENT_DATE as Day_diference,

year(BIRTHDATE)-year(INCIDENT_DATE ) as year_diference,

age(BIRTHDATE,INCIDENT_DATE ) as age_diference

from ...

maxgro — Wed, 27 Jul 2016 17:01:37 GMT

you can but the 2 fields should be in the same table; if not, join the tables or use (if possible) a mapping load

interval example in script

load

interval(today() - (today()-rand()))

AutoGenerate 10;