Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

amiroh81
New Contributor

Add null value

Hello everyone,

There is QVD which contains four columns,

I would like to add a column where there are values ​​equal to NULL.

How do I do this?

Of course I can add a new column with a value other than NULL.

Thanks in advance everyone.

1 Reply
sushil353
Honored Contributor II

Re: Add null value

Hi,

Try something like

if(isnull(coulmn),'Y',coulmn)

HTH

Sushil

Community Browser