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

Help Needed in Script using IF & ISNULL

 

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
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
Partner - Master III
Partner - Master III

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

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)