Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bobbydave
Contributor III

Date difference in two tables

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?

1 Solution

Accepted Solutions
MVP
MVP

Re: Date difference in two tables

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;

2 Replies
Not applicable

Re: Date difference in two tables

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 ...

MVP
MVP

Re: Date difference in two tables

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;