topic Re: listbox connections in QlikView https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859446#M1005714 <HTML><HEAD></HEAD><BODY><P>You meant a literal table box object? If it is a table box object than you will need to push the whole table to the alternate state. Else you can mimic a table box using a straight table and use alternate state in set analysis of the expression <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 14 May 2015 11:12:11 GMT sunny_talwar 2015-05-14T11:12:11Z listbox connections https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859443#M1005711 <HTML><HEAD></HEAD><BODY><P>is there a way to make a listbox effect only one table, but not the other tables?</P><P></P><P>thanks.</P></BODY></HTML> Thu, 14 May 2015 10:54:49 GMT https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859443#M1005711 Anonymous 2015-05-14T10:54:49Z Re: listbox connections https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859444#M1005712 <HTML><HEAD></HEAD><BODY><P>Create an alternate state and then push this list box to the alternate state and refer the alternate state in set analysis of your one table.</P><P></P><P>HTH</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 14 May 2015 11:04:53 GMT https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859444#M1005712 sunny_talwar 2015-05-14T11:04:53Z Re: listbox connections https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859445#M1005713 <HTML><HEAD></HEAD><BODY><P>how do we use the alternate state in the set analysis of table?</P></BODY></HTML> Thu, 14 May 2015 11:09:44 GMT https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859445#M1005713 Anonymous 2015-05-14T11:09:44Z Re: listbox connections https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859446#M1005714 <HTML><HEAD></HEAD><BODY><P>You meant a literal table box object? If it is a table box object than you will need to push the whole table to the alternate state. Else you can mimic a table box using a straight table and use alternate state in set analysis of the expression <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 14 May 2015 11:12:11 GMT https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859446#M1005714 sunny_talwar 2015-05-14T11:12:11Z Re: listbox connections https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859447#M1005715 <HTML><HEAD></HEAD><BODY><P>could you tell me where do ı put the alternate state here?</P><P></P><P>=If(not(IsNull(ID))and not(IsNull(ACTV)) ,'YES','NO')</P><P></P><P>this is the expression that ı use in my table.</P></BODY></HTML> Thu, 14 May 2015 11:23:00 GMT https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859447#M1005715 Anonymous 2015-05-14T11:23:00Z Re: listbox connections https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859448#M1005716 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=If(not(IsNull(<STRONG>Only({NameOfAlternateState}</STRONG> ID<STRONG>)</STRONG>))and not(IsNull(<STRONG style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Only({NameOfAlternateState} </STRONG>ACTV<STRONG>)</STRONG>)) ,'YES','NO')</SPAN></P></BODY></HTML> Thu, 14 May 2015 11:32:34 GMT https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859448#M1005716 sunny_talwar 2015-05-14T11:32:34Z Re: listbox connections https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859449#M1005717 <HTML><HEAD></HEAD><BODY><P>Although I am not sure if Qlik Sense has Alternate State. If it doesn't have alternate state than you will have to go a longer route of adding <STRONG>{&lt;ListBox = &gt;} </STRONG>to all your other objects where you don't want ListBox selections to impact anything in that table.</P><P></P><P>Hope this make sense.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 14 May 2015 11:35:14 GMT https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859449#M1005717 sunny_talwar 2015-05-14T11:35:14Z Re: listbox connections https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859450#M1005718 <HTML><HEAD></HEAD><BODY><P>ı have made it "new to qliksense" by mistake, it is under new to qlikview.</P><P></P><P>ı corrected it.</P></BODY></HTML> Thu, 14 May 2015 11:39:24 GMT https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859450#M1005718 Anonymous 2015-05-14T11:39:24Z Re: listbox connections https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859451#M1005719 <HTML><HEAD></HEAD><BODY><P>‌Oh okay... Then you should be able to use the above expression with alternate state in set analysis. See if that worked?</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 14 May 2015 11:46:52 GMT https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859451#M1005719 sunny_talwar 2015-05-14T11:46:52Z Re: listbox connections https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859452#M1005720 <HTML><HEAD></HEAD><BODY><P>sunindia thank you so much.</P><P></P><P>it worked.</P></BODY></HTML> Thu, 14 May 2015 14:14:21 GMT https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859452#M1005720 Anonymous 2015-05-14T14:14:21Z Re: listbox connections https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859453#M1005721 <HTML><HEAD></HEAD><BODY><P>Awesome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 14 May 2015 14:20:41 GMT https://community.qlik.com/t5/QlikView/listbox-connections/m-p/859453#M1005721 sunny_talwar 2015-05-14T14:20:41Z