Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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.
Are TRIAGE,ARRIVAL and OBS HANDOFF date fields?
Yes sir, sorry for not mentioning that, they are date fields.
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
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