topic Re: Creating a list table based on two or more tables and using Is Null in QlikView

Creating a list table based on two or more tables and using Is Null

Wed, 09 Sep 2015 15:33:30 GMT

Hello,

I was wondering if I could get some guidance on how to create a table by creating a new column in my data. Currently I have:

AdmitDate, (format: M/D/YYYY)

DischargeDate (format: M/D/YYYY)

I want to create a LOS (length of stay) column that is based on the Admit and Discharge Dates:

LOS = DischargeDate - AdmitDate

In addition, if the DischargeDate column is NULL (or empty: no discharge date), then the LOS would be:

LOS= TODAY - AdmitDate.

I want to do this in the load script, but do not know the syntax to use. Any help is very appreciated.

settu_periasamy — Wed, 09 Sep 2015 15:39:49 GMT

Hi,

Try this

If (len (dischargedate)>0,num (dischargedate)-num (admitdate),num (today ())-num (admitdate)) as LOS

maxgro — Wed, 09 Sep 2015 15:57:39 GMT

try with

alt(DischargeDate - AdmitDate, today() - AdmitDate)

Wed, 09 Sep 2015 16:08:18 GMT

Thank you, this worked like a charm!

Wed, 09 Sep 2015 16:09:53 GMT

This works as well! Thank you, now I have two options.