Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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
Partner

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