topic Re: If Statement Help in QlikView

If Statement Help

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: If Statement Help

oscar_ortiz — Mon, 28 Aug 2017 18:23:40 GMT

Tyler,

You can try something like this:

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

Good luck!

Oscar

Re: If Statement Help

MarcoWedel — Mon, 28 Aug 2017 20:58:14 GMT

please post some sample data and your expected result.

thanks

regards

Marco

Re: If Statement Help

sasiparupudi1 — Tue, 29 Aug 2017 17:49:19 GMT

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

Hth

Sasi

Re: If Statement Help

oscar_ortiz — Wed, 30 Aug 2017 13:52:35 GMT

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

Re: If Statement Help

anindya_manna — Wed, 30 Aug 2017 14:04:05 GMT

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

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