topic Re: Detach a table from one list box selection among multiple list selection... in QlikView https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263264#M398216 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>use this</P><P></P><P>Sum({&lt;<STRONG>ListBoxField</STRONG>=&gt;}Sales)</P><P></P><P>like above,In your set expression mention your listbox. then it will restrict the selections for that particular table.</P><P></P><P>HTH,</P><P>Hirish</P></BODY></HTML> Thu, 23 Mar 2017 05:18:28 GMT HirisH_V7 2017-03-23T05:18:28Z Detach a table from one list box selection among multiple list selection... https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263261#M398213 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need to detach a table from one particular list box selection among multiple list box selections.... That table should not have any interaction when the user made any selection on the specific list box&nbsp; and the same time the values of the table should remain constant for the selections made...</P><P></P><P></P><P></P><P>Any Idea?</P><P></P><P></P><P></P><P>Regards,</P><P>Jegadeesan G</P></BODY></HTML> Thu, 23 Mar 2017 04:29:12 GMT https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263261#M398213 jegadeesan 2017-03-23T04:29:12Z Re: Detach a table from one list box selection among multiple list selection... https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263262#M398214 <HTML><HEAD></HEAD><BODY><P>Hi Jegadeesan,</P><P></P><P>Use set analysis like this to exclude tha selection in <SPAN style="font-size: 13.3333px;">[Excluded Field]</SPAN> field: Sum({&lt;[Excluded Field]=&gt;} Amount)</P><P></P><P>Regards,</P><P>H</P></BODY></HTML> Thu, 23 Mar 2017 04:37:22 GMT https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263262#M398214 hector_munoz 2017-03-23T04:37:22Z Re: Detach a table from one list box selection among multiple list selection... https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263263#M398215 <HTML><HEAD></HEAD><BODY><P>Hi Munoz,</P><P>Dimension of the table is Brand and the table should not interact for the specific list box dimension also brand... How to do this?</P><P></P><P></P><P>Regards,</P><P>Jegadeesan G</P></BODY></HTML> Thu, 23 Mar 2017 04:58:18 GMT https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263263#M398215 jegadeesan 2017-03-23T04:58:18Z Re: Detach a table from one list box selection among multiple list selection... https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263264#M398216 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>use this</P><P></P><P>Sum({&lt;<STRONG>ListBoxField</STRONG>=&gt;}Sales)</P><P></P><P>like above,In your set expression mention your listbox. then it will restrict the selections for that particular table.</P><P></P><P>HTH,</P><P>Hirish</P></BODY></HTML> Thu, 23 Mar 2017 05:18:28 GMT https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263264#M398216 HirisH_V7 2017-03-23T05:18:28Z Re: Detach a table from one list box selection among multiple list selection... https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263265#M398217 <HTML><HEAD></HEAD><BODY><P>Then: <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum({&lt;Brand=&gt;} Amount)</SPAN></P></BODY></HTML> Thu, 23 Mar 2017 07:59:49 GMT https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263265#M398217 hector_munoz 2017-03-23T07:59:49Z Re: Detach a table from one list box selection among multiple list selection... https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263266#M398218 <HTML><HEAD></HEAD><BODY><P>Hi Munoz,</P><P></P><P>It doesn't works to my case.... am getting the value along with the dimension used in List box....</P><P></P><P></P><P>Regards,</P><P>Jegadeesan G</P></BODY></HTML> Thu, 23 Mar 2017 10:09:07 GMT https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263266#M398218 jegadeesan 2017-03-23T10:09:07Z Re: Detach a table from one list box selection among multiple list selection... https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263267#M398219 <HTML><HEAD></HEAD><BODY><P>Hi Harish,</P><P></P><P>It doesn't works to my case.... am getting the value along with the dimension used in List box....</P><P></P><P></P><P>Regards,</P><P>Jegadeesan G</P></BODY></HTML> Thu, 23 Mar 2017 10:09:33 GMT https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263267#M398219 jegadeesan 2017-03-23T10:09:33Z Re: Detach a table from one list box selection among multiple list selection... https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263268#M398220 <HTML><HEAD></HEAD><BODY><P>Could you attach a sample?</P><P>Regards,<BR />H</P></BODY></HTML> Thu, 23 Mar 2017 12:23:51 GMT https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263268#M398220 hector_munoz 2017-03-23T12:23:51Z Re: Detach a table from one list box selection among multiple list selection... https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263269#M398221 <HTML><HEAD></HEAD><BODY><P><IMG alt="Atlernate.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/157251_Atlernate.PNG" style="height: auto;" /></P><P></P><P>The given table should not interact to the rounded list box selections...There are some other object in this sheet for this selection... </P></BODY></HTML> Thu, 23 Mar 2017 12:35:36 GMT https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263269#M398221 jegadeesan 2017-03-23T12:35:36Z Re: Detach a table from one list box selection among multiple list selection... https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263270#M398222 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi Jegadeesan,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I think the problem could be that you are using in set analysis the name of the listbox object (i.e. "Brand") instead of the name of the field in the model <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(i.e. [Brand Description)</SPAN>. You have to use the name of the field in set analysis.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Could you try it?</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Regards,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">H</P></BODY></HTML> Thu, 23 Mar 2017 12:43:06 GMT https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263270#M398222 hector_munoz 2017-03-23T12:43:06Z Re: Detach a table from one list box selection among multiple list selection... https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263271#M398223 <HTML><HEAD></HEAD><BODY><P>I used the name of the field in model Munoz...</P><P></P><P>Regards,</P><P>Jegadeesan G</P></BODY></HTML> Thu, 23 Mar 2017 12:48:13 GMT https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263271#M398223 jegadeesan 2017-03-23T12:48:13Z Re: Detach a table from one list box selection among multiple list selection... https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263272#M398224 <HTML><HEAD></HEAD><BODY><P>OK, could you attach a QVW file?</P></BODY></HTML> Thu, 23 Mar 2017 13:56:44 GMT https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263272#M398224 hector_munoz 2017-03-23T13:56:44Z Re: Detach a table from one list box selection among multiple list selection... https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263273#M398225 <HTML><HEAD></HEAD><BODY><P>it works , very useful !! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 01 Aug 2018 09:37:23 GMT https://community.qlik.com/t5/QlikView/Detach-a-table-from-one-list-box-selection-among-multiple-list/m-p/1263273#M398225 bouderbc 2018-08-01T09:37:23Z