If Statement Help

[#1]

Hey, I am trying to write an if statement to say if the status is "Done" before the "Target Date", it was delivered "On-Time"...if not, it is "Late".  How would I do this in an if statement?

[oscar_ortiz]

Tyler,

You can try something like this:

If ( StatusDate < TargetDate, 'On-Time', 'Late') as Status

Good luck!

Oscar

[MarcoWedel]

please post some sample data and your expected result.

thanks

regards

Marco

[sasiparupudi1]

If ( (Status='Done' and StatusDate < TargetDate), 'On-Time', 'Late') as Status

Hth

Sasi

[oscar_ortiz]

Tyler,

If anyone was helpful or if they answered your question would you please close the post.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks

Oscar

[anindya_manna]

If ( (Status='Done' and StatusDate <= TargetDate), 'On-Time', 'Late') as Status

Just make sure that status date and target date are in same format.