Help Needed in Script using IF & ISNULL

[AbdullahJamil]

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])))))
))))

[Miguel_Angel_Baeyens]

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/NULLF...

[agigliotti]

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

[AbdullahJamil]

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)