topic Re: Using If function with ISNULL function - need help in QlikView

Using If function with ISNULL function - need help

AbdullahJamil — Wed, 25 Nov 2020 16:16:04 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: Using If function with ISNULL function - need help

miskinmaz — Tue, 30 Jul 2019 08:52:38 GMT

What is the problem and what is the expected output

Re: Using If function with ISNULL function - need help

AbdullahJamil — Tue, 30 Jul 2019 10:36:27 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)

Re: Using If function with ISNULL function - need help

Brett_Bleess — Wed, 21 Aug 2019 14:59:34 GMT

Duplicate post, see https://community.qlik.com/t5/QlikView-Scripting/Help-Needed-in-Script-using-IF-amp-ISNULL/m-p/1607370#M96064 for continuing thread.

Regards,
Brett