topic Re: Help Needed in Script using IF & ISNULL in QlikView

Help Needed in Script using IF & ISNULL

AbdullahJamil — Tue, 30 Jul 2019 08:53:03 GMT

Hi Guys,

Can anyone help in correcting my below coding.

Thanks

if(Process='PA'
,NetWorkDays([14. Tracking DCC response to PA]
,[01. Confirm impact for PA]
)
,if(Process='IA'
,NetWorkDays([30. Tracking DCC response to IA]
,if(IsNull([18. Mobilise virtual team for IA]
,if (IsNull([17. Confirm demand]
,[01. Confirm impact for PA])

)
)
)
)
, if(Process='CAN'
,Networkdays([36. Complete]
,if (IsNull([31. Resolve DCC IA queries.]
,if(IsNull([30. Tracking DCC response to IA]
,[01. Confirm impact for PA])))))
))))

Re: Help Needed in Script using IF & ISNULL

Miguel_Angel_Baeyens — Tue, 30 Jul 2019 08:58:55 GMT

What do you want to achieve? The code itself does not look wrong, other than some misplaced "()" in the IsNull() functions, which only take one parameter:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/NULLFunctions/IsNull.htm

Re: Help Needed in Script using IF & ISNULL

agigliotti — Tue, 30 Jul 2019 09:04:14 GMT

what is the business logic behind process = IA and process = CAN ?

Re: Help Needed in Script using IF & ISNULL

AbdullahJamil — Tue, 30 Jul 2019 09:57:50 GMT

I need to make below mentioned table. required result is monthly average days occur in theses categories ( PA , IA & CAN)

Months	May	Jun	Jul	Description
PA				Step 14 date - Step 01 date. average days in month (Month considered from Step 14 date)
IA				Step 30 date - Step 18 date if empty - step 17 date if empty - step 01 date. average days in month (Month considered from Step 30 date)
CAN				Step 36 date- Step 31 date if empty - step 30 date if empty - step 01 date . average days in month (Month considered from Step 36 date)