topic Have fields from a table in a dropdown to populate a variable? in QlikView https://community.qlik.com/t5/QlikView/Have-fields-from-a-table-in-a-dropdown-to-populate-a-variable/m-p/696942#M251743 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>How can I make a dropdown select (input box with constraint on predefined values in Drop-down) that has its list populated from a table? Cheers.</P></BODY></HTML> Thu, 25 Sep 2014 13:52:38 GMT richnorris 2014-09-25T13:52:38Z Have fields from a table in a dropdown to populate a variable? https://community.qlik.com/t5/QlikView/Have-fields-from-a-table-in-a-dropdown-to-populate-a-variable/m-p/696942#M251743 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>How can I make a dropdown select (input box with constraint on predefined values in Drop-down) that has its list populated from a table? Cheers.</P></BODY></HTML> Thu, 25 Sep 2014 13:52:38 GMT https://community.qlik.com/t5/QlikView/Have-fields-from-a-table-in-a-dropdown-to-populate-a-variable/m-p/696942#M251743 richnorris 2014-09-25T13:52:38Z Re: Have fields from a table in a dropdown to populate a variable? https://community.qlik.com/t5/QlikView/Have-fields-from-a-table-in-a-dropdown-to-populate-a-variable/m-p/696943#M251744 <HTML><HEAD></HEAD><BODY><P>Choose <EM>Predefined Values in Drop-down</EM> and enable the option<EM> Listed Values</EM> and enter an expression to created a comma separated list: <EM>=concat(distinct MyFieldHere, ',')</EM></P></BODY></HTML> Thu, 25 Sep 2014 13:56:59 GMT https://community.qlik.com/t5/QlikView/Have-fields-from-a-table-in-a-dropdown-to-populate-a-variable/m-p/696943#M251744 Gysbert_Wassenaar 2014-09-25T13:56:59Z Re: Have fields from a table in a dropdown to populate a variable? https://community.qlik.com/t5/QlikView/Have-fields-from-a-table-in-a-dropdown-to-populate-a-variable/m-p/696944#M251745 <HTML><HEAD></HEAD><BODY><P>Fantastic, thanks!</P></BODY></HTML> Thu, 25 Sep 2014 13:58:54 GMT https://community.qlik.com/t5/QlikView/Have-fields-from-a-table-in-a-dropdown-to-populate-a-variable/m-p/696944#M251745 richnorris 2014-09-25T13:58:54Z