topic Copy the field if value is Null in QlikView

Copy the field if value is Null

prabunakil — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Copy the field if value is Null

qlikviewwizard — Thu, 08 Nov 2018 02:04:32 GMT

Your requirement is not clear.

Can you explain in details with the example,please?

Re: Copy the field if value is Null

prabunakil — Thu, 08 Nov 2018 02:19:18 GMT

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.

Re: Copy the field if value is Null

tharanikannan — Thu, 08 Nov 2018 03:10:19 GMT

Use somethimg like this,

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

in your table.

Thanks,

Tharani.

Re: Copy the field if value is Null

prabunakil — Thu, 08 Nov 2018 06:34:24 GMT

It did not work