topic Re: How to build a dropdown combining the values from multiple data tables that are not associated in App Development https://community.qlik.com/t5/App-Development/How-to-build-a-dropdown-combining-the-values-from-multiple-data/m-p/1277951#M26541 <HTML><HEAD></HEAD><BODY><P>If the fields have the same name in each table, then they ARE associated, A list box for each field will hold the distinct values in all tables by default. Selecting something in them will filter all the tables by default.</P><P></P><P>Or have I misunderstood your problem?</P><P></P><P>BTW - please use a normal font size in your posts.</P></BODY></HTML> Thu, 02 Feb 2017 06:28:07 GMT jonathandienst 2017-02-02T06:28:07Z How to build a dropdown combining the values from multiple data tables that are not associated https://community.qlik.com/t5/App-Development/How-to-build-a-dropdown-combining-the-values-from-multiple-data/m-p/1277950#M26540 <HTML><HEAD></HEAD><BODY><P style="margin: 0 0 1em; font-size: 32.4819px; color: #242729; font-family: Arial, 'Helvetica Neue', Helvetica, sans-serif;">I have 3 data tables. Each table has two common fields called FirstName, LastName. All 3 will remain unassociated in the data model. Each data table is associated to one qliksense table in the UI.</P><P style="margin: 0 0 1em; font-size: 32.4819px; color: #242729; font-family: Arial, 'Helvetica Neue', Helvetica, sans-serif;">I need to build 1 dropdown filter for FirstName and 1 for LastName that holds the unique values from all 3 data tables combined and ultimately filter all 3 tables at the same time when selected.</P><P style="margin: 0 0 1em; font-size: 32.4819px; color: #242729; font-family: Arial, 'Helvetica Neue', Helvetica, sans-serif;">Greatly appreciate any insight on how to do this.</P></BODY></HTML> Thu, 02 Feb 2017 03:52:42 GMT https://community.qlik.com/t5/App-Development/How-to-build-a-dropdown-combining-the-values-from-multiple-data/m-p/1277950#M26540 2017-02-02T03:52:42Z Re: How to build a dropdown combining the values from multiple data tables that are not associated https://community.qlik.com/t5/App-Development/How-to-build-a-dropdown-combining-the-values-from-multiple-data/m-p/1277951#M26541 <HTML><HEAD></HEAD><BODY><P>If the fields have the same name in each table, then they ARE associated, A list box for each field will hold the distinct values in all tables by default. Selecting something in them will filter all the tables by default.</P><P></P><P>Or have I misunderstood your problem?</P><P></P><P>BTW - please use a normal font size in your posts.</P></BODY></HTML> Thu, 02 Feb 2017 06:28:07 GMT https://community.qlik.com/t5/App-Development/How-to-build-a-dropdown-combining-the-values-from-multiple-data/m-p/1277951#M26541 jonathandienst 2017-02-02T06:28:07Z Re: How to build a dropdown combining the values from multiple data tables that are not associated https://community.qlik.com/t5/App-Development/How-to-build-a-dropdown-combining-the-values-from-multiple-data/m-p/1277952#M26542 <HTML><HEAD></HEAD><BODY><P>Forgive me for not elaborating.&nbsp; I'm trying to avoid synthetic tables and columns as I've been told they are bad practice.</P></BODY></HTML> Thu, 02 Feb 2017 17:22:58 GMT https://community.qlik.com/t5/App-Development/How-to-build-a-dropdown-combining-the-values-from-multiple-data/m-p/1277952#M26542 2017-02-02T17:22:58Z