Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try like:
if(Match(transaction_type_code,'expense' , 'load', 'correction'),0,amount_positive)
thanks! then it works!
or
if(transaction_type_code='expense' or transaction_type_code='load' or transaction_type_code='correction',0,amount_positive)