topic Create a list box from a count/lookup table in QlikView https://community.qlik.com/t5/QlikView/Create-a-list-box-from-a-count-lookup-table/m-p/391021#M145837 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a lookup table with the following data:</P><P></P><P>PropertyID&nbsp;&nbsp;&nbsp;&nbsp; Bedrooms</P><P>202123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>202123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>202123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>303567&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>303567&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P></P><P>When I count the bedrooms of these properties I have the following:</P><P>202123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>303567&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P></P><P>How can I create a list box where the user can select 2 bedrooms from a drop down menu?</P><P></P><P>Thanks in advance,</P><P>Darren</P></BODY></HTML> Tue, 23 Apr 2013 14:11:17 GMT darren_dixon 2013-04-23T14:11:17Z Create a list box from a count/lookup table https://community.qlik.com/t5/QlikView/Create-a-list-box-from-a-count-lookup-table/m-p/391021#M145837 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a lookup table with the following data:</P><P></P><P>PropertyID&nbsp;&nbsp;&nbsp;&nbsp; Bedrooms</P><P>202123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>202123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>202123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>303567&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>303567&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P></P><P>When I count the bedrooms of these properties I have the following:</P><P>202123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>303567&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P></P><P>How can I create a list box where the user can select 2 bedrooms from a drop down menu?</P><P></P><P>Thanks in advance,</P><P>Darren</P></BODY></HTML> Tue, 23 Apr 2013 14:11:17 GMT https://community.qlik.com/t5/QlikView/Create-a-list-box-from-a-count-lookup-table/m-p/391021#M145837 darren_dixon 2013-04-23T14:11:17Z Re: Create a list box from a count/lookup table https://community.qlik.com/t5/QlikView/Create-a-list-box-from-a-count-lookup-table/m-p/391022#M145838 <HTML><HEAD></HEAD><BODY><P>Put an expression in the listbox:</P><P></P><P>=AGGR(SUM(Bedrooms), PropertyID)</P><P></P><P>Cheers</P></BODY></HTML> Tue, 23 Apr 2013 14:22:22 GMT https://community.qlik.com/t5/QlikView/Create-a-list-box-from-a-count-lookup-table/m-p/391022#M145838 2013-04-23T14:22:22Z