topic Re: How to Clear 'Always One Selected Value' ? in QlikView https://community.qlik.com/t5/QlikView/How-to-Clear-Always-One-Selected-Value/m-p/1364527#M514451 <HTML><HEAD></HEAD><BODY><P>Ok, try this: </P><P></P><P>In Settings &gt; Document Properties &gt; Triggers &gt; Field Event Triggers (Highlight the field) &gt; OnSelect Add Action(s).</P><P></P><P>Click Add &gt; Selection &gt; Select in Field.&nbsp; Enter the field name, then this expression in the Search String. </P><P></P><P>=SubField(GetFieldSelections(yourfield), ',', 1)</P><P></P><P>Press OK and you should be done.</P><P></P><P>Here is a thread for reference: <A href="https://community.qlik.com/thread/2315">list box - how to force to choose only one value</A></P></BODY></HTML> Tue, 11 Jul 2017 14:36:21 GMT jcampbell474 2017-07-11T14:36:21Z How to Clear 'Always One Selected Value' ? https://community.qlik.com/t5/QlikView/How-to-Clear-Always-One-Selected-Value/m-p/1364523#M514447 <HTML><HEAD></HEAD><BODY><P>In a selection object, it is useful to tick the option 'Always One Selected Value'. This means that only one value can be selected at a time.</P><P>However, I need to also be able to clear all selections on the field to see all values.</P><P></P><P>Is there any way to achieve this ?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 11 Jul 2017 14:14:14 GMT https://community.qlik.com/t5/QlikView/How-to-Clear-Always-One-Selected-Value/m-p/1364523#M514447 richard_chilvers 2017-07-11T14:14:14Z Re: How to Clear 'Always One Selected Value' ? https://community.qlik.com/t5/QlikView/How-to-Clear-Always-One-Selected-Value/m-p/1364524#M514448 <HTML><HEAD></HEAD><BODY><P><SPAN>Not aware of a straightforward way to do what you're describing with the Always One Selected Value property checked.&nbsp; However, there are some ideas/workarounds in this thread: </SPAN><A class="jive-link-thread-small" data-containerid="2051" data-containertype="14" data-objectid="36497" data-objecttype="1" href="https://community.qlik.com/thread/36497">https://community.qlik.com/thread/36497</A></P></BODY></HTML> Tue, 11 Jul 2017 14:20:59 GMT https://community.qlik.com/t5/QlikView/How-to-Clear-Always-One-Selected-Value/m-p/1364524#M514448 jcampbell474 2017-07-11T14:20:59Z Re: How to Clear 'Always One Selected Value' ? https://community.qlik.com/t5/QlikView/How-to-Clear-Always-One-Selected-Value/m-p/1364525#M514449 <HTML><HEAD></HEAD><BODY><P>Look for DV solution. Tested and and it's working</P><P><A href="https://community.qlik.com/thread/36497">How to clear the Always One selected value</A></P></BODY></HTML> Tue, 11 Jul 2017 14:22:06 GMT https://community.qlik.com/t5/QlikView/How-to-Clear-Always-One-Selected-Value/m-p/1364525#M514449 Anil_Babu_Samineni 2017-07-11T14:22:06Z Re: How to Clear 'Always One Selected Value' ? https://community.qlik.com/t5/QlikView/How-to-Clear-Always-One-Selected-Value/m-p/1364526#M514450 <HTML><HEAD></HEAD><BODY><P><EM>As per I know their is not direct method ..we need to use the macro for the same</EM></P></BODY></HTML> Tue, 11 Jul 2017 14:25:22 GMT https://community.qlik.com/t5/QlikView/How-to-Clear-Always-One-Selected-Value/m-p/1364526#M514450 avinashelite 2017-07-11T14:25:22Z Re: How to Clear 'Always One Selected Value' ? https://community.qlik.com/t5/QlikView/How-to-Clear-Always-One-Selected-Value/m-p/1364527#M514451 <HTML><HEAD></HEAD><BODY><P>Ok, try this: </P><P></P><P>In Settings &gt; Document Properties &gt; Triggers &gt; Field Event Triggers (Highlight the field) &gt; OnSelect Add Action(s).</P><P></P><P>Click Add &gt; Selection &gt; Select in Field.&nbsp; Enter the field name, then this expression in the Search String. </P><P></P><P>=SubField(GetFieldSelections(yourfield), ',', 1)</P><P></P><P>Press OK and you should be done.</P><P></P><P>Here is a thread for reference: <A href="https://community.qlik.com/thread/2315">list box - how to force to choose only one value</A></P></BODY></HTML> Tue, 11 Jul 2017 14:36:21 GMT https://community.qlik.com/t5/QlikView/How-to-Clear-Always-One-Selected-Value/m-p/1364527#M514451 jcampbell474 2017-07-11T14:36:21Z Re: How to Clear 'Always One Selected Value' ? https://community.qlik.com/t5/QlikView/How-to-Clear-Always-One-Selected-Value/m-p/1364528#M514452 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>maybe you could adapt one of this solutions to your requirements?:</P><P></P><P><A href="https://community.qlik.com/thread/254772">How to you always select multiple fields in a list box: Qlikview 12</A></P><P></P><P><A href="https://community.qlik.com/thread/253869">Listbox object to show always one selected value with flexibility to select more than one value from the list</A></P><P></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 11 Jul 2017 20:39:04 GMT https://community.qlik.com/t5/QlikView/How-to-Clear-Always-One-Selected-Value/m-p/1364528#M514452 MarcoWedel 2017-07-11T20:39:04Z Re: How to Clear 'Always One Selected Value' ? https://community.qlik.com/t5/QlikView/How-to-Clear-Always-One-Selected-Value/m-p/1364529#M514453 <HTML><HEAD></HEAD><BODY><P>maybe using one of these expressions as search string in a search in field action at the OnSelect field event trigger of the your field (year in this example):</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14998076591164732" jivemacro_uid="_14998076591164732"> <P>=If(GetSelectedCount(Year)&gt;1,Only({$1} Year),Only(Year))</P> </PRE><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14998076558532522" jivemacro_uid="_14998076558532522"> <P>=Only($(=If(GetSelectedCount(Year)&gt;1,'{$1}','')) Year)</P> </PRE><P></P><P>see <SPAN style="font-size: 13.3333px;">attached </SPAN>example</P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 11 Jul 2017 21:14:51 GMT https://community.qlik.com/t5/QlikView/How-to-Clear-Always-One-Selected-Value/m-p/1364529#M514453 MarcoWedel 2017-07-11T21:14:51Z