https://community.qlik.com/t5/QlikView/Combine-Different-columns-into-listbox/m-p/1623758#M732963 <P>Hi</P><P>you could do it using crosstable&nbsp;</P><P>After that, you could filter your data adding where value = 1</P> Fri, 13 Sep 2019 14:46:26 GMT StarinieriG 2019-09-13T14:46:26Z https://community.qlik.com/t5/QlikView/Combine-Different-columns-into-listbox/m-p/1623757#M732961 <P>Hi Everyone,&nbsp;</P><P>How do I combine different columns into one dimension for a list box.&nbsp;</P><P>So I have data in the form:</P><TABLE border="1"><TBODY><TR><TD>Customer_ID</TD><TD>Current_Account</TD><TD>Savings_Account</TD><TD>Loan_Account</TD></TR><TR><TD>1001</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>1002</TD><TD>0</TD><TD>0</TD><TD>1</TD></TR><TR><TD>1003</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>For each account, 1 or 0 represents the customer having the account or not.&nbsp;</P><P>I want to populate a listbox of account types with the contents</P><P>Current_Account</P><P>Savings_Account</P><P>Loan_Account</P><P>&nbsp;</P><P>So on click of any of the options, all customers that have the the account type are filtered, and vice versa.&nbsp; Is this possible please?</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Combine-Different-columns-into-listbox/m-p/1623757#M732961 joejobs 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Combine-Different-columns-into-listbox/m-p/1623758#M732963 <P>Hi</P><P>you could do it using crosstable&nbsp;</P><P>After that, you could filter your data adding where value = 1</P> Fri, 13 Sep 2019 14:46:26 GMT https://community.qlik.com/t5/QlikView/Combine-Different-columns-into-listbox/m-p/1623758#M732963 StarinieriG 2019-09-13T14:46:26Z