Hi everyone,
I'm new to Qlik and was looking to get familiar with the different Syntax. I
need help with this below expression:
if([COMPLETED AT]>0,if(CREA1='FBIMPORT', if([COMPLETED
AT]>[CreateDate]), if(networkdays([COMPLETED AT], [CreateDate])-1))<=([Transit
Days], 1, 0)))
I keep getting an error in the expression.
The Completed At field is the date and time of shipment
The CreateDate field is the date and time the shipment was created
The Transit Days field is the Expected Transit Days it takes for a shipment
to arrive to a destination
Can anyone help me with this expression to make it valid?
Thanks a million!
Oz
