Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

prabunakil
New Contributor III

Copy the field if value is Null

Capture.JPG

how to write script if the childmaterial field is null, copy the material value to the child material value.

but if child material value field have items, then no need to do anythings.

4 Replies
Arjunarao
Honored Contributor II

Re: Copy the field if value is Null

Your requirement is not clear.

Can you explain in details with the example,please?

prabunakil
New Contributor III

Re: Copy the field if value is Null

Hi Arjun

This table is combine with two SQL,

1st SQL table include of Material , Description

2nd SQL Table include of Material, ChildMaterial, ChildDescription.

Both SQL is link by Material

so if my child material , exist, my field will show child material, but if child material is empty, i would like to copy the material to the child material field.

tharanikannan
New Contributor III

Re: Copy the field if value is Null

Hi

Use somethimg like this,

if (isnull(ChildMaterial),Material, ChildMaterial) as MaterialID

in your table.

Thanks,

Tharani.

prabunakil
New Contributor III

Re: Copy the field if value is Null

It did not work