Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

If Or

Hi Experts 🙂

I have a question regarding IF(OR syntaks with several parameters:

If (PurchaseOrderHeader_StatusWms) is Closed, or Locked or Received than I need to return Arrived, 

If (PurchaseOrderHeader_StatusWms) is Sent, I need to return Planned

If (PurchaseOrderHeader_StatusWms) is None, I need to return Not Planned

 

I hope you can help me.

Thank you

 

Labels (1)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Many thanks Marcus. It works perfectly 🙂 🙂
You made my day ....

View solution in original post

3 Replies
marcus_sommer

It would be possible to create a nested if-loop including your OR's but better would be to use:

pick(match(PurchaseOrderHeader_StatusWms,
    'Closed', 'Locked', 'Received', 'Sent', 'None'),
    'Arrived', 'Arrived', 'Arrived', 'Planned', 'Not Planned')

- Marcus

Anonymous
Not applicable
Author

Many thanks Marcus. It works perfectly 🙂 🙂
You made my day ....
passionate
Specialist
Specialist

Try implementing Marcus solution in backend for better performance.