topic Re: NVL in qlikview? in QlikView

NVL in qlikview?

narender123 — Mon, 07 Sep 2015 06:06:38 GMT

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 — Mon, 07 Sep 2015 06:13:34 GMT

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 — Mon, 07 Sep 2015 07:51:50 GMT

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;