Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prabunakil
Contributor III
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
qlikviewwizard
Master II
Master II

Your requirement is not clear.

Can you explain in details with the example,please?

prabunakil
Contributor III
Contributor III
Author

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
Contributor III
Contributor III

Hi

Use somethimg like this,

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

in your table.

Thanks,

Tharani.

prabunakil
Contributor III
Contributor III
Author

It did not work