topic Re: Filterable List Box in QlikView https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802308#M473359 <HTML><HEAD></HEAD><BODY><P>So my issue is that if i Select Texas, then I am only getting one row returned and not all of the Texas rows</P></BODY></HTML> Mon, 10 Nov 2014 16:14:54 GMT 2014-11-10T16:14:54Z Filterable List Box https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802302#M473353 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a strait table and i want to make the values within columns filterable.&nbsp; For instance, if a select a value then the whole table filters on that particular value.&nbsp; How is this achieved??&nbsp; I do not want to have a list box for this.</P><P></P><P>Thank you.</P></BODY></HTML> Mon, 10 Nov 2014 16:00:10 GMT https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802302#M473353 2014-11-10T16:00:10Z Re: Filterable List Box https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802303#M473354 <HTML><HEAD></HEAD><BODY><P>Can you elaborate little more please? if possible, please give one small example</P></BODY></HTML> Mon, 10 Nov 2014 16:01:08 GMT https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802303#M473354 MK_QSL 2014-11-10T16:01:08Z Re: Filterable List Box https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802304#M473355 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use set analysis for current selection.write the set analysis in straight table whatever you want filter condition</P></BODY></HTML> Mon, 10 Nov 2014 16:04:13 GMT https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802304#M473355 2014-11-10T16:04:13Z Re: Filterable List Box https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802305#M473356 <HTML><HEAD></HEAD><BODY><P>Yes.&nbsp; Lets say that my table looks like this:</P><P></P><P>Geography&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Name&nbsp;&nbsp;&nbsp;&nbsp; Sales</P><P>Texas&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24</P><P>Texas&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jim&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18&nbsp;&nbsp;&nbsp;&nbsp; </P><P>New Mexico&nbsp;&nbsp;&nbsp;&nbsp; Jen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>Arizona&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jerry&nbsp;&nbsp;&nbsp;&nbsp; 18</P><P></P><P>and so I select 'Texas', then i see</P><P></P><P style="font-size: 13.6000003814697px;">Geography&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Name&nbsp;&nbsp;&nbsp;&nbsp; Sales</P><P style="font-size: 13.6000003814697px;">Texas&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; John&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24</P><P style="font-size: 13.6000003814697px;">Texas&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jim&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Mon, 10 Nov 2014 16:05:15 GMT https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802305#M473356 2014-11-10T16:05:15Z Re: Filterable List Box https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802306#M473357 <HTML><HEAD></HEAD><BODY><P>come up with little bit clear</P></BODY></HTML> Mon, 10 Nov 2014 16:05:16 GMT https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802306#M473357 2014-11-10T16:05:16Z Re: Filterable List Box https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802307#M473358 <HTML><HEAD></HEAD><BODY><P>Of cource, you will get only Texas data once you select Texas... What is your question?</P></BODY></HTML> Mon, 10 Nov 2014 16:12:58 GMT https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802307#M473358 MK_QSL 2014-11-10T16:12:58Z Re: Filterable List Box https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802308#M473359 <HTML><HEAD></HEAD><BODY><P>So my issue is that if i Select Texas, then I am only getting one row returned and not all of the Texas rows</P></BODY></HTML> Mon, 10 Nov 2014 16:14:54 GMT https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802308#M473359 2014-11-10T16:14:54Z Re: Filterable List Box https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802309#M473360 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P><BR />If you slect texas by default it will give output how you need.tell me wats your exact requirement</P></BODY></HTML> Mon, 10 Nov 2014 16:14:55 GMT https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802309#M473360 2014-11-10T16:14:55Z Re: Filterable List Box https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802310#M473361 <HTML><HEAD></HEAD><BODY><P>So my issue is that when i select Texas, I am just getting back one row of Teas....not all of the Texas values, which is what I want</P></BODY></HTML> Mon, 10 Nov 2014 16:16:44 GMT https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802310#M473361 2014-11-10T16:16:44Z Re: Filterable List Box https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802311#M473362 <HTML><HEAD></HEAD><BODY><P>Provide your table dimension and expressions...</P></BODY></HTML> Mon, 10 Nov 2014 16:17:08 GMT https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802311#M473362 MK_QSL 2014-11-10T16:17:08Z Re: Filterable List Box https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802312#M473363 <HTML><HEAD></HEAD><BODY><P>So name is my dimension and all of the other columns are expressions</P></BODY></HTML> Mon, 10 Nov 2014 16:20:03 GMT https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802312#M473363 2014-11-10T16:20:03Z Re: Filterable List Box https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802313#M473364 <HTML><HEAD></HEAD><BODY><P>What is the expression for <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Geography ?</SPAN></P></BODY></HTML> Mon, 10 Nov 2014 16:21:29 GMT https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802313#M473364 MK_QSL 2014-11-10T16:21:29Z Re: Filterable List Box https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802314#M473365 <HTML><HEAD></HEAD><BODY><P>it is just the field name</P></BODY></HTML> Mon, 10 Nov 2014 16:23:21 GMT https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802314#M473365 2014-11-10T16:23:21Z Re: Filterable List Box https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802315#M473366 <HTML><HEAD></HEAD><BODY><P>Remove Geography from expression and place it as a Dimension</P></BODY></HTML> Mon, 10 Nov 2014 16:33:01 GMT https://community.qlik.com/t5/QlikView/Filterable-List-Box/m-p/802315#M473366 MK_QSL 2014-11-10T16:33:01Z