Discussion Board for collaboration related to QlikView App Development.
Can anyone help in correcting my below coding.
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])))))))))
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:
what is the business logic behind process = IA and process = CAN ?
I need to make below mentioned table. required result is monthly average days occur in theses categories ( PA , IA & CAN)