Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stvegerton
Creator III
Creator III

Green-white-gray not working for new list box

Hello, I'm creating a new table and the typical green-white-gray will not work when I create a list box for CMPNY_CODE even though I see the tables are auto joined correctly by CMPNY_CODE.

COMPANY_CODES:

LOAD

CMPNY_CODE_ID,

REGION_NAME as CMPNY_REGION_NAME,

CMPNY_CODE_FULL_NAME &'-'& COUNTRY_NAME &'-'& REGION_NAME as COMPANY

FROM (qvd);

15 Replies
Anonymous
Not applicable

I've seen this happen in a couple of places.

Right-click the object and make sure that it is "Attached."

If there is an option to Attach it, do so. Otherwise it may be associated with an alternate state.

stvegerton
Creator III
Creator III
Author

It's strange. I have no option to attach and the alternate state is = "inherited".

JonnyPoole
Employee
Employee

I don't see 'CMPNY_CODE' in the load script  you posted. Can you screenshot your data model ? 

stvegerton
Creator III
Creator III
Author

Here's my latest script. Getting the same behavior:

COMPANY_DESC:

add LOAD CMPNY_CODE_ID,   

CMPNY_DESC,   

CMPNY_CODE_ID&'-'&CMPNY_DESC as COMPANY       

FROM (biff, embedded labels, table is CMPNY_DESC$);

stvegerton
Creator III
Creator III
Author

Whoops. Here's the data model: COPA_DATA_MODEL.jpg

Anonymous
Not applicable

I assume you're looking at CMPNY_CODE_ID for your list box.

It may well be that even though the fields are named the same, they are not linking because you have some white space or something causing them to be different. Try Trim(CMPNY_CODE_ID) as CMPNY_CODE_ID in your load script.

Anonymous
Not applicable

For both tables.

rustyfishbones
Master II
Master II

Can you check that the COMPANY_DESC is not loosely coupled like below image

You can check this in Setting>> Document Properties >> Tables

2014-10-24_2027.png

stvegerton
Creator III
Creator III
Author

Will try. Thanks.