topic IF statement that don't works in QlikView

IF statement that don't works

Aika — Tue, 06 Jul 2021 09:48:02 GMT

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)

Re: IF statement that don't works

tresB — Tue, 06 Jul 2021 09:56:45 GMT

Try like:

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

Re: IF statement that don't works

Aika — Tue, 06 Jul 2021 10:14:55 GMT

thanks! then it works!

Re: IF statement that don't works

avinashelite — Tue, 06 Jul 2021 10:18:25 GMT

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