topic Calculated Filter Pane / Set Analysis - Can Only Select One Value in App Development https://community.qlik.com/t5/App-Development/Calculated-Filter-Pane-Set-Analysis-Can-Only-Select-One-Value/m-p/61111#M4016 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I am using the following for a calculated filter pane in Sense:</P><P></P><P>AGGR(Only({&lt;Publisher_Code = {$(vOWNPUBCODE)}&gt;} "My Publisher"),"My Publisher")</P><P></P><P>The problem I have is this will only permit selection of one value, or an invalid parameter error appears - probably due to the only function.</P><P></P><P>Does anyone have a solution / workaround?</P><P></P><P>Thanks!</P></BODY></HTML> Sat, 16 Nov 2024 08:27:20 GMT Anonymous 2024-11-16T08:27:20Z Calculated Filter Pane / Set Analysis - Can Only Select One Value https://community.qlik.com/t5/App-Development/Calculated-Filter-Pane-Set-Analysis-Can-Only-Select-One-Value/m-p/61111#M4016 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I am using the following for a calculated filter pane in Sense:</P><P></P><P>AGGR(Only({&lt;Publisher_Code = {$(vOWNPUBCODE)}&gt;} "My Publisher"),"My Publisher")</P><P></P><P>The problem I have is this will only permit selection of one value, or an invalid parameter error appears - probably due to the only function.</P><P></P><P>Does anyone have a solution / workaround?</P><P></P><P>Thanks!</P></BODY></HTML> Sat, 16 Nov 2024 08:27:20 GMT https://community.qlik.com/t5/App-Development/Calculated-Filter-Pane-Set-Analysis-Can-Only-Select-One-Value/m-p/61111#M4016 Anonymous 2024-11-16T08:27:20Z Re: Calculated Filter Pane / Set Analysis - Can Only Select One Value https://community.qlik.com/t5/App-Development/Calculated-Filter-Pane-Set-Analysis-Can-Only-Select-One-Value/m-p/61112#M4017 <HTML><HEAD></HEAD><BODY><P>How about this?</P><P></P><P><STRONG>Aggr(Only({<SPAN style="color: #ff0000;">1</SPAN>&lt;Publisher_Code = {$(vOWNPUBCODE)}&gt;} "My Publisher"),"My Publisher")</STRONG></P></BODY></HTML> Thu, 05 Apr 2018 14:57:41 GMT https://community.qlik.com/t5/App-Development/Calculated-Filter-Pane-Set-Analysis-Can-Only-Select-One-Value/m-p/61112#M4017 sunny_talwar 2018-04-05T14:57:41Z Re: Calculated Filter Pane / Set Analysis - Can Only Select One Value https://community.qlik.com/t5/App-Development/Calculated-Filter-Pane-Set-Analysis-Can-Only-Select-One-Value/m-p/61113#M4018 <HTML><HEAD></HEAD><BODY><P>Perfect, exactly what I needed!!! Thank you!!!!!</P></BODY></HTML> Thu, 05 Apr 2018 15:40:41 GMT https://community.qlik.com/t5/App-Development/Calculated-Filter-Pane-Set-Analysis-Can-Only-Select-One-Value/m-p/61113#M4018 Anonymous 2018-04-05T15:40:41Z