topic Re: Scripting - Filling Null values in QlikView

Scripting - Filling Null values

Ramsingh — Mon, 26 Jan 2026 18:19:17 GMT

Hi All ,

Have kind of basic question i guess
Need help

I have table with 2 fields

ID's Name

1 Apple

2 Orange

3 Mango

1_1 -

1_2 -

1_3 -

2_2 -

3_1 -

3_2 -

I have above table where Names are null for 1_1 , 1_2 ,1_3 ,2_2,3_1,3_2

I could require below table as output ( To be done in Backend )

ID's Name

1 Apple

2 Orange

3 Mango

1_1 Apple

1_2 Apple

1_3 Apple

2_2 Orange

3_1 Mango

3_2 Mango

Basically for the null values , based on left of ( before underscore ex 1_1 , 2_2) and map with above ID's and get the names

Advance Thanks

Re: Scripting - Filling Null values

Brett_Bleess — Tue, 08 Sep 2020 19:16:01 GMT

I think you will need the following:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/StringFunctions/SubField.htm

The other option may be a Mapping load I think:

https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-and-not-the-geographical-kind/ba-p/1463192

About the best I have to try to get you on the right track with things, there are likely other ways as well. if you did not search Community for prior posts, try that too, as I know there are others out there like this.

Regards,
Brett