topic Re: Calculation in Load in QlikView

Calculation in Load

fcecconi — Fri, 06 May 2016 16:58:16 GMT

I would like to create a field that is the subtraction of 2 items. However 1 item I want to take the min value of. I would like something like this.

(Min(%ProgramAdmitDate_Num,1) - %EncounterAdmitDate_Num) as Program_delay

I am getting an error with this statement.

Thanks in advance for your help!

Frank

sunny_talwar — Fri, 06 May 2016 17:00:20 GMT

Can you share the complete script for this table? and is the min overall min or min by some dimension in this table?

fcecconi — Fri, 06 May 2016 17:06:29 GMT

Here is the full statement

I am joining this data to a Patient Summary table

Join

Load

[Patient ID#],

(Min(%ProgramAdmitDate_Num,1) - %EncounterAdmitDate_Num) as Program_delay

Resident Fact

Where not IsNull(%ProgramDischargeDate_Num) and EncounterStatus ='Discharged' and RecoveryType='InPatient';

sunny_talwar — Fri, 06 May 2016 17:08:34 GMT

Try this:

Join (Fact)

Load [Patient ID#],

(Min(%ProgramAdmitDate_Num,1) as Min

Resident Fact

Where not IsNull(%ProgramDischargeDate_Num) and EncounterStatus ='Discharged' and RecoveryType='InPatient'

Group By [Patient ID#];

NewFact:

LOAD *,

Min - %EncounterAdmitDate_Num as Program_delay

Resident Fact;

DROP

Table Fact;