topic Re: Creation listbox for the same name fields in QlikView

Creation listbox for the same name fields

Anonymous — Mon, 21 May 2018 08:40:42 GMT

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.

Re: Creation listbox for the same name fields

isingh30 — Mon, 21 May 2018 16:22:42 GMT

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

Thank you!

Re: Creation listbox for the same name fields

vishsaggi — Mon, 21 May 2018 16:23:07 GMT

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?

Re: Creation listbox for the same name fields

Anonymous — Tue, 22 May 2018 04:04:43 GMT

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

Re: Creation listbox for the same name fields

vishsaggi — Tue, 22 May 2018 15:56:29 GMT

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

Re: Creation listbox for the same name fields

rwunderlich — Tue, 22 May 2018 16:00:47 GMT

Try Qualifying only fname.

Qualify fname;

-Rob

http://masterssummit.com

http://qlikviewcookbook.com