Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

resident tables - values not being passed

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;

1 Solution

Accepted Solutions
MVP
MVP

resident tables - values not being passed

Brianm10,

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

2 Replies
MVP
MVP

resident tables - values not being passed

Brianm10,

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

Not applicable

resident tables - values not being passed

argh... my mistake

Thanks

Community Browser