NVL in qlikview?

[narender123]

Hi Team,

I have a table having multiple columns.condition like:-

if(isnull(tp_type),doc_type,tp_type) 

Here tp_type and doc_type are columns of same table.

I want to use this ,  if tp_type is null then it will show doc_type records else tp_type  records.

Its working but i want to use it for row based means check row by row .

Thanks,

Narender

[PrashantSangle]

Hi,

Posted expression must work.

Can you post sample apps or explain with sample data.

Note : Check tp_type does not contain space try like

if(len(trim(tp_type))=0,doc_type,tp_type)

Regards,

[qlikviewwizard]

Hi ,

Please try the below expression:

Data:

LOAD

Column1,

Column2,

Column3,

.

.

.

.

if(len(trim(tp_type))=0,doc_type,tp_type) as Field_Name

From QVD/TableName;