Discussion board where members can get started with QlikView.
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.
Your requirement is not clear.
Can you explain in details with the example,please?
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.
Use somethimg like this,
if (isnull(ChildMaterial),Material, ChildMaterial) as MaterialID
in your table.
It did not work