New to Qlik..need help writing an expression!

[okamal99]

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

[jduenyas]

Please review the Parenthesis count and order of operation. It seems to be bad.

Besides you need to be careful when converting or manipulating dates.