topic Re: Exclude an Alternate State group in QlikView https://community.qlik.com/t5/QlikView/Exclude-an-Alternate-State-group/m-p/1128837#M898426 <HTML><HEAD></HEAD><BODY><P>I am not sure what you are trying to do. Would you be able to elaborate a little more?</P></BODY></HTML> Fri, 22 Jul 2016 15:55:01 GMT sunny_talwar 2016-07-22T15:55:01Z Exclude an Alternate State group https://community.qlik.com/t5/QlikView/Exclude-an-Alternate-State-group/m-p/1128833#M898422 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have an object which I do not want it to be affected by a trigger. And the only way I found was by manipulating the expression, something like:</P><P></P><P>=If(GetSelectedCount(ID)&gt;0, Concat(DISTINCT EmployeeID, ', '), '')</P><P></P><P>Is is possible to add the alternate state group in it but by excluding it.</P><P></P><P>All I could find was how to include it, example:</P><P></P><P><SPAN style="font-size: 13.3333px;">=If(GetSelectedCount(ID)&gt;0, Concat( <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>{AlternateStateA}</STRONG> </SPAN>DISTINCT EmployeeID, ', '), '')</SPAN></P><P></P><P>Is it possible to exclude the state?</P><P></P><P></P><P>Thanks, </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Exclude-an-Alternate-State-group/m-p/1128833#M898422 2020-11-25T16:16:04Z Re: Exclude an Alternate State group https://community.qlik.com/t5/QlikView/Exclude-an-Alternate-State-group/m-p/1128834#M898423 <HTML><HEAD></HEAD><BODY><P>What about this?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=If(GetSelectedCount(ID)&gt;0, Concat(<SPAN style="color: #ff0000;">{$}</SPAN> DISTINCT EmployeeID, ', '), '')</STRONG></SPAN></P></BODY></HTML> Fri, 22 Jul 2016 15:11:01 GMT https://community.qlik.com/t5/QlikView/Exclude-an-Alternate-State-group/m-p/1128834#M898423 sunny_talwar 2016-07-22T15:11:01Z Re: Exclude an Alternate State group https://community.qlik.com/t5/QlikView/Exclude-an-Alternate-State-group/m-p/1128835#M898424 <HTML><HEAD></HEAD><BODY><P>I will give it a try, dont know if it will work for that particular solution...thank you.</P></BODY></HTML> Fri, 22 Jul 2016 15:14:52 GMT https://community.qlik.com/t5/QlikView/Exclude-an-Alternate-State-group/m-p/1128835#M898424 2016-07-22T15:14:52Z Re: Exclude an Alternate State group https://community.qlik.com/t5/QlikView/Exclude-an-Alternate-State-group/m-p/1128836#M898425 <HTML><HEAD></HEAD><BODY><P>As I thought... the object (table chart) will still being affected by that selection. Thats why I thought of the alternate states.&nbsp; </P></BODY></HTML> Fri, 22 Jul 2016 15:20:06 GMT https://community.qlik.com/t5/QlikView/Exclude-an-Alternate-State-group/m-p/1128836#M898425 2016-07-22T15:20:06Z Re: Exclude an Alternate State group https://community.qlik.com/t5/QlikView/Exclude-an-Alternate-State-group/m-p/1128837#M898426 <HTML><HEAD></HEAD><BODY><P>I am not sure what you are trying to do. Would you be able to elaborate a little more?</P></BODY></HTML> Fri, 22 Jul 2016 15:55:01 GMT https://community.qlik.com/t5/QlikView/Exclude-an-Alternate-State-group/m-p/1128837#M898426 sunny_talwar 2016-07-22T15:55:01Z