Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Creation listbox for the same name fields

I have two tables, one called a customer and one order.I want to create 2 LISTBOX for the field (FNAME) for each table 1 but can not be named because of the names of the fields.

1.png2.png3.png

5 Replies
isingh30
Specialist
Specialist

Their is synthetic key in your model. Please rename national_code & then create the list box.

Thank you!

vishsaggi
Champion III
Champion III

you seem to have synthetic keys in your data model. Can you tell what is the linking key between both the tables? And what is that you are expecting to see as your output?

Anonymous
Not applicable
Author

Field natonal_code is the external key, but I want to field fname 2, I create a box, one for customer the table one for order the table.When I use it QUALIFY, my problem is solved, but the connection to the table is dropped

vishsaggi
Champion III
Champion III

When you press Ctrl+T to view table viewer can you share your model how it looks. ?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Try Qualifying only fname.

Qualify fname;

-Rob

http://masterssummit.com

http://qlikviewcookbook.com