topic Re: Convert Excel Formula into Qlikview Script!!!! Please help in QlikView

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

Anonymous — Tue, 09 Aug 2016 16:43:06 GMT

=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 — Tue, 09 Aug 2016 17:05:02 GMT

Are TRIAGE,ARRIVAL and OBS HANDOFF date fields?

Anonymous — Tue, 09 Aug 2016 17:10:16 GMT

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

Clever_Anjos — Tue, 09 Aug 2016 17:28:24 GMT

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 — Tue, 11 Feb 2020 09:25:14 GMT

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