Convert Excel Formula into Qlikview Script!!!! Please help

[Anonymous]

=IF(IF([@[OBS HANDOFF]]="","",

IFERROR(([@[OBS HANDOFF]]-MIN([@TRIAGE],[@ARRIVAL]))*24,0))<0,"",

IF([@[OBS HANDOFF]]="","",

IFERROR(([@[OBS HANDOFF]]-MIN([@TRIAGE],[@ARRIVAL]))*24,"")))

Qlikview gurus please help me convert this 'excel' formula into a executable qlikview script. You help will be appreciated. 

Thank you

Note: You can ignore the '@' signs infront of some fields.

[Clever_Anjos]

Are TRIAGE,ARRIVAL and OBS HANDOFF date fields?

[Anonymous]

Yes sir, sorry for not mentioning that, they are date fields.

[Clever_Anjos]

Let me try to understand

If  [OBS HANDOFF] - MIN(@TRIAGE]) IS NULL OR ERROR RETURN  ARRIVAL, right?

Maybe this can work

Alt(

[OBS HANDOFF] - MIN(@TRIAGE]) ,

ARRIVAL

) * 24

[sakshikaul]

Hi,

Please help me in writing an executable script for below given excel formula.

iferror(if(E22<>"1",((vlookup(Z22,Master!$G:$I,3,0)),"check"),"check")

I have tried writing following executable script in  qlikview :-

if(damage_tag<>1, applymap('part_no',material,'check')) as abc,

this is not giving correct result.. please help