topic Re: LISTBOX FILTERING BASED ON RESULT in QlikView https://community.qlik.com/t5/QlikView/LISTBOX-FILTERING-BASED-ON-RESULT/m-p/488030#M182356 <HTML><HEAD></HEAD><BODY><P>Thx very much</P></BODY></HTML> Fri, 27 Sep 2013 14:28:19 GMT 2013-09-27T14:28:19Z LISTBOX FILTERING BASED ON RESULT https://community.qlik.com/t5/QlikView/LISTBOX-FILTERING-BASED-ON-RESULT/m-p/488028#M182354 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P></P><P>I have a probleme in my document : I load 3 columns with 2 values for each.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Name</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Salary</TH></TR><TR><TD style="padding: 2px;">Alex</TD><TD style="padding: 2px;">500</TD></TR><TR><TD style="padding: 2px;">Chang</TD><TD style="padding: 2px;">1400</TD></TR><TR><TD style="padding: 2px;">Romain</TD><TD style="padding: 2px;">1500</TD></TR></TBODY></TABLE><P></P><P>I make a graph-table with an expression like that :</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Name</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Salary</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Group</TH></TR><TR><TD style="padding: 2px;">=Name</TD><TD style="padding: 2px;">=Salary</TD><TD style="padding: 2px;">=If(Salary&gt;1000,'Group1',Group2)</TD></TR><TR><TD style="padding: 2px;">Alex</TD><TD style="padding: 2px;">500</TD><TD style="padding: 2px;">Group1</TD></TR><TR><TD style="padding: 2px;">Chang</TD><TD style="padding: 2px;">1000</TD><TD style="padding: 2px;">Group2</TD></TR><TR><TD style="padding: 2px;">Romain</TD><TD style="padding: 2px;">1500</TD><TD style="padding: 2px;">Group2</TD></TR></TBODY></TABLE><P></P><P>I would like to make a listbox which present the two possible value which are generated by the "group column expression" (=If(Salary&gt;1000,'Group1',Group2))</P><P></P><P>My user select Group1 on a list box and the table is refresh with only the Group1 value.</P><P></P><P>Thx a lot</P></BODY></HTML> Fri, 27 Sep 2013 12:34:02 GMT https://community.qlik.com/t5/QlikView/LISTBOX-FILTERING-BASED-ON-RESULT/m-p/488028#M182354 2013-09-27T12:34:02Z Re: LISTBOX FILTERING BASED ON RESULT https://community.qlik.com/t5/QlikView/LISTBOX-FILTERING-BASED-ON-RESULT/m-p/488029#M182355 <HTML><HEAD></HEAD><BODY><P>Put your formula: =If(Salary&gt;1000,'Group1',Group2)&nbsp;&nbsp;&nbsp; in the expression.</P><P><IMG alt="Untitled2.png" class="jive-image jiveImage" src="https://community.qlik.com/legacyfs/online/46995_Untitled2.png" /></P></BODY></HTML> Fri, 27 Sep 2013 12:39:00 GMT https://community.qlik.com/t5/QlikView/LISTBOX-FILTERING-BASED-ON-RESULT/m-p/488029#M182355 tresB 2013-09-27T12:39:00Z Re: LISTBOX FILTERING BASED ON RESULT https://community.qlik.com/t5/QlikView/LISTBOX-FILTERING-BASED-ON-RESULT/m-p/488030#M182356 <HTML><HEAD></HEAD><BODY><P>Thx very much</P></BODY></HTML> Fri, 27 Sep 2013 14:28:19 GMT https://community.qlik.com/t5/QlikView/LISTBOX-FILTERING-BASED-ON-RESULT/m-p/488030#M182356 2013-09-27T14:28:19Z