topic Re: Values from two fields in same listbox? in QlikView https://community.qlik.com/t5/QlikView/Values-from-two-fields-in-same-listbox/m-p/357800#M492938 <HTML><HEAD></HEAD><BODY><P>ok, could you precise me if you need to do that in the script or directly in the list? (In the list, it's working)</P></BODY></HTML> Mon, 18 Jun 2012 18:34:52 GMT 2012-06-18T18:34:52Z Values from two fields in same listbox? https://community.qlik.com/t5/QlikView/Values-from-two-fields-in-same-listbox/m-p/357797#M492935 <HTML><HEAD></HEAD><BODY><P>Is there anyway I can use an expression or something to put the values of two different fields in the same list box?</P></BODY></HTML> Mon, 18 Jun 2012 15:47:46 GMT https://community.qlik.com/t5/QlikView/Values-from-two-fields-in-same-listbox/m-p/357797#M492935 2012-06-18T15:47:46Z Re: Values from two fields in same listbox? https://community.qlik.com/t5/QlikView/Values-from-two-fields-in-same-listbox/m-p/357798#M492936 <HTML><HEAD></HEAD><BODY><P>=field1 &amp; field2</P></BODY></HTML> Mon, 18 Jun 2012 16:13:31 GMT https://community.qlik.com/t5/QlikView/Values-from-two-fields-in-same-listbox/m-p/357798#M492936 2012-06-18T16:13:31Z Re: Values from two fields in same listbox? https://community.qlik.com/t5/QlikView/Values-from-two-fields-in-same-listbox/m-p/357799#M492937 <HTML><HEAD></HEAD><BODY><P>Sorry, forgot the caveat of from two different tables.</P></BODY></HTML> Mon, 18 Jun 2012 18:30:26 GMT https://community.qlik.com/t5/QlikView/Values-from-two-fields-in-same-listbox/m-p/357799#M492937 2012-06-18T18:30:26Z Re: Values from two fields in same listbox? https://community.qlik.com/t5/QlikView/Values-from-two-fields-in-same-listbox/m-p/357800#M492938 <HTML><HEAD></HEAD><BODY><P>ok, could you precise me if you need to do that in the script or directly in the list? (In the list, it's working)</P></BODY></HTML> Mon, 18 Jun 2012 18:34:52 GMT https://community.qlik.com/t5/QlikView/Values-from-two-fields-in-same-listbox/m-p/357800#M492938 2012-06-18T18:34:52Z Re: Values from two fields in same listbox? https://community.qlik.com/t5/QlikView/Values-from-two-fields-in-same-listbox/m-p/357801#M492939 <HTML><HEAD></HEAD><BODY><P>Create a list box and in the properties, instead of choosing a field name, choose &lt;expression&gt;. Then, in the expression dialog box, try this:&nbsp;&nbsp;&nbsp; =FIELD1 &amp; ' - ' &amp; FIELD2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; then click OK. You will then have a list box that shows all of the combinations of the two field values that occur in the data separated by a hyphen (you can format that any way you like). A single click on the values shown in the list box selects the corresponding value from each of the two fields at once.&nbsp; </P></BODY></HTML> Tue, 19 Jun 2012 20:16:59 GMT https://community.qlik.com/t5/QlikView/Values-from-two-fields-in-same-listbox/m-p/357801#M492939 2012-06-19T20:16:59Z