Discussion Board for collaboration related to Qlik Education.
I have two columns customer,Currency
If customer is null and Currency is null.I want to replace null in customer with some text ex;'Speciality'
How can I achieve this?
You can do something like
if(customer=null() and Currency=null(), 'Speciality', customer) AS customer,
if(IsNull(customer) and IsNull(currrency), 'Speciality', customer) as customer
if(len(trim(customer))=0 and len(trim(currrency))=0, 'Speciality', customer) as customer