Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

verifying null in two caolumns

Hi All,

I have two columns customer,Currency

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?

Thanks,

Mahendra.

2 Replies
Employee
Employee

Re: verifying null in two caolumns

Hi Mahendra

You can do something like

load

  if(customer=null() and Currency=null(), 'Speciality', customer) AS customer,

  Currency

FROM ...

Agis

MVP
MVP

Re: verifying null in two caolumns

if(IsNull(customer) and IsNull(currrency), 'Speciality', customer) as customer

or

if(len(trim(customer))=0 and len(trim(currrency))=0, 'Speciality', customer) as customer

Community Browser