Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
PrashantRupani
Creator
Creator

If or statement qlik sense

Hi,

I need to write a statement  using if in QS.

If order status = ORDERED or NOT SHIPPED then 1 else 0.

How do I write using QS compliant syntax? 

Thanks

Labels (1)
1 Reply
JuanGerardo
Partner - Specialist
Partner - Specialist

If([Order Status] = 'ORDERED' Or [Order Status] = 'NOT SHIPPED', 1, 0)