Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Aika
Contributor III
Contributor III

IF statement that don't works

I need to write a simple IF statement in Qlik, that says if the value is type "load" and "correction", then display the value as 0. Otherwise complete the expression.
I have the following statement that don't works... and there is a sintax error :"missing right bracket"

if(transaction_type_code='expense' or 'load' or 'correction',0,amount_positive)

3 Replies
tresesco
MVP
MVP

Try like:

if(Match(transaction_type_code,'expense' , 'load', 'correction'),0,amount_positive)

Aika
Contributor III
Contributor III
Author

thanks! then it works!

avinashelite

or

 

if(transaction_type_code='expense' or  transaction_type_code='load' or transaction_type_code='correction',0,amount_positive)