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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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)