topic Re: Single button which toggles between two combinations of multiple field selections (and changes colour as it does so)? in QlikView https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395732#M569777 <HTML><HEAD></HEAD><BODY><P>What a neat trick to use * -1</P></BODY></HTML> Sat, 27 Oct 2012 00:35:19 GMT 2012-10-27T00:35:19Z Single button which toggles between two combinations of multiple field selections (and changes colour as it does so)? https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395725#M569767 <HTML><HEAD></HEAD><BODY><P>Been wrestling with this one for a while now and not coming right. Please can someone help me resolve. In QV11SR1</P><P></P><P>I wish to have a single button which toggles between two combinations of multiple field selections (and changes colour as it does so)</P><P></P><P>The change colour part works fine but not the select field</P><P></P><P>I have tried umpteen combinations of things, as per <A _jive_internal="true" class="loading" href="https://community.qlik.com/thread/11809" title="http://community.qlik.com/thread/11809">http://community.qlik.com/thread/11809</A> and <A _jive_internal="true" class="loading" href="https://community.qlik.com/message/65538#65538" title="http://community.qlik.com/message/65538">http://community.qlik.com/message/65538</A> etc</P><P></P><P>Please see attached example QVW with my code.</P><P></P><P>I have a field MarketingGender and I want the button to toggle between the selections of (M|B) and (L|G).</P><P></P><P>I do not want to select ALL fields or select (M|B|L|G) at once. Somehow I need to clear the selected field between toggles but that doesnt work for me either.</P><P></P><P>I just want to have the following 2 selection states when I toggle the button:</P><P></P><P><IMG __jive_id="23170" alt="t1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/23170_t1.png" /></P><P>or</P><P><IMG __jive_id="23171" alt="t2.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/23171_t2.png" /></P><P>How can I achieve this. Thanks</P></BODY></HTML> Tue, 09 Oct 2012 16:17:59 GMT https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395725#M569767 2012-10-09T16:17:59Z Re: Single button which toggles between two combinations of multiple field selections (and changes colour as it does so)? https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395726#M569768 <HTML><HEAD></HEAD><BODY><P>See attached; I think that works like you want.</P><P></P><P>If you have questions on this, let me know.</P></BODY></HTML> Tue, 09 Oct 2012 16:30:41 GMT https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395726#M569768 2012-10-09T16:30:41Z Re: Single button which toggles between two combinations of multiple field selections (and changes colour as it does so)? https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395727#M569769 <HTML><HEAD></HEAD><BODY><P>It works for me using a select of:</P><P></P><P>=If($(vGender) = -1, 'M', 'L')</P><P></P><P>and then the B/G as the following toggle select. The clear is not necessary.</P><P></P><P>Note that the variable test is backwards because the variable value doesn't actually change until the actions are complete. </P><P></P><P>Example attached.</P><P></P><P>-Rob</P><P><A class="jive-link-external-small" href="http://robwunderlich.com">http://robwunderlich.com</A></P></BODY></HTML> Tue, 09 Oct 2012 16:33:33 GMT https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395727#M569769 rwunderlich 2012-10-09T16:33:33Z Re: Single button which toggles between two combinations of multiple field selections (and changes colour as it does so)? https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395728#M569770 <HTML><HEAD></HEAD><BODY><P>Awesome <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Thank you Roberto and Rob, both of your solutions work perfectly for what I want to do here.</P></BODY></HTML> Tue, 09 Oct 2012 17:41:58 GMT https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395728#M569770 2012-10-09T17:41:58Z Re: Single button which toggles between two combinations of multiple field selections (and changes colour as it does so)? https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395729#M569774 <HTML><HEAD></HEAD><BODY><P>Nice!</P><P>Perhaps it is required that your name starts with <STRONG>Rob</STRONG> to know such things <span class="lia-unicode-emoji" title=":winking_face_with_tongue:">😜</span></P></BODY></HTML> Tue, 09 Oct 2012 17:50:39 GMT https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395729#M569774 2012-10-09T17:50:39Z Re: Single button which toggles between two combinations of multiple field selections (and changes colour as it does so)? https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395730#M569775 <HTML><HEAD></HEAD><BODY><P>Using the * -1 is a great trick.&nbsp; Thanks!</P></BODY></HTML> Sat, 27 Oct 2012 00:34:47 GMT https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395730#M569775 2012-10-27T00:34:47Z Re: Single button which toggles between two combinations of multiple field selections (and changes colour as it does so)? https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395731#M569776 <HTML><HEAD></HEAD><BODY><P>Using the * -1 is a great trick.&nbsp; Thanks!</P></BODY></HTML> Sat, 27 Oct 2012 00:34:54 GMT https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395731#M569776 2012-10-27T00:34:54Z Re: Single button which toggles between two combinations of multiple field selections (and changes colour as it does so)? https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395732#M569777 <HTML><HEAD></HEAD><BODY><P>What a neat trick to use * -1</P></BODY></HTML> Sat, 27 Oct 2012 00:35:19 GMT https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395732#M569777 2012-10-27T00:35:19Z Re: Single button which toggles between two combinations of multiple field selections (and changes colour as it does so)? https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395733#M569778 <HTML><HEAD></HEAD><BODY><P>Hehe thanks! </P><P>Happy Qlikviewing!</P></BODY></HTML> Sun, 28 Oct 2012 19:01:08 GMT https://community.qlik.com/t5/QlikView/Single-button-which-toggles-between-two-combinations-of-multiple/m-p/395733#M569778 2012-10-28T19:01:08Z