Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
AbdullahJamil
Contributor III
Contributor III

Using If function with ISNULL function - need help

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

 

 

3 Replies
miskinmaz
Creator III
Creator III

What is the problem and what is the expected output
AbdullahJamil
Contributor III
Contributor III
Author

 

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

MonthsMayJunJulDescription
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)
Brett_Bleess
Employee
Employee

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

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.