Discussion board where members can get started with QlikView.
I can use an expression to say INTERVAL(BIRTHDATE-INCIDENT_DATE, 'YY')
However, I am wondering how I do this in the script?
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
interval(today() - (today()-rand()))
View solution in original post
do you can make direcly...but you tables need stay thogether...
BIRTHDATE-INCIDENT_DATE as Day_diference,
year(BIRTHDATE)-year(INCIDENT_DATE ) as year_diference,
age(BIRTHDATE,INCIDENT_DATE ) as age_diference