resident tables - values not being passed

Mon, 26 Jan 2026 18:19:17 GMT

On the following code the field 'CatEDesc' does not hold any data. In my QV app when I select a listbox with the value 'CatEDesc' nothing is returned under that value.

However if I have a listbox with 'MATERIAL DESCRIPTION' im given all the product descriptions. Am i missing something here, why cant the values from MATERIAL_DESCRIPTION be passed onto CatEDesc?

(In my table 'COPA', you have the MATERIAL_DESCRIPTION. There are no issues with this table.)

Any help would be greatly appreciated. Thanks

groupedCodes:

NOCONCATENATE LOAD

PROD_HIER as prod_h,

MATL_GROUP,

left(PROD_HIER,2)&'00000000' as CatACode,

left(PROD_HIER,4)&'000000' as CatBCode,

left(PROD_HIER,6)&'0000' as CatCCode,

left(PROD_HIER,8)&'00' as CatDCode,

MATERIAL_DESCRIPTION as CatEDesc

RESIDENT COPA

where len(PROD_HIER)=10;

resident tables - values not being passed

swuehl — Sat, 29 Oct 2011 11:19:46 GMT

Brianm10,

you probably checked that you have also MATERIAL_DESCRIPTION values in table COPA where len(PROD_HIER)=10?

resident tables - values not being passed

Sat, 29 Oct 2011 11:33:02 GMT

argh... my mistake

Thanks

topic resident tables - values not being passed in QlikView

resident tables - values not being passed

resident tables - values not being passed

resident tables - values not being passed