topic select same value in other field in QlikView https://community.qlik.com/t5/QlikView/select-same-value-in-other-field/m-p/62923#M788443 <HTML><HEAD></HEAD><BODY><P>I have two fields in Qlikview with the same values.</P><P></P><P>Values:</P><P></P><P>Field1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Field2</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C</P><P>D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D</P><P></P><P>When i select in field 1 value B&nbsp;&nbsp;&nbsp; i like to have field 2 value B also selected.</P><P>And when i change a value in Field 1 also field2 must change with same value.</P><P></P><P>Is this possible and how?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT francisvandergr 2020-11-25T16:16:04Z select same value in other field https://community.qlik.com/t5/QlikView/select-same-value-in-other-field/m-p/62923#M788443 <HTML><HEAD></HEAD><BODY><P>I have two fields in Qlikview with the same values.</P><P></P><P>Values:</P><P></P><P>Field1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Field2</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C</P><P>D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; D</P><P></P><P>When i select in field 1 value B&nbsp;&nbsp;&nbsp; i like to have field 2 value B also selected.</P><P>And when i change a value in Field 1 also field2 must change with same value.</P><P></P><P>Is this possible and how?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/select-same-value-in-other-field/m-p/62923#M788443 francisvandergr 2020-11-25T16:16:04Z Re: select same value in other field https://community.qlik.com/t5/QlikView/select-same-value-in-other-field/m-p/62924#M788444 <HTML><HEAD></HEAD><BODY><P>You can use Triggers to do this... </P></BODY></HTML> Wed, 21 Feb 2018 12:29:53 GMT https://community.qlik.com/t5/QlikView/select-same-value-in-other-field/m-p/62924#M788444 sunny_talwar 2018-02-21T12:29:53Z Re: select same value in other field https://community.qlik.com/t5/QlikView/select-same-value-in-other-field/m-p/62925#M788445 <HTML><HEAD></HEAD><BODY><P>What trigger?</P></BODY></HTML> Wed, 21 Feb 2018 12:31:48 GMT https://community.qlik.com/t5/QlikView/select-same-value-in-other-field/m-p/62925#M788445 francisvandergr 2018-02-21T12:31:48Z Re: select same value in other field https://community.qlik.com/t5/QlikView/select-same-value-in-other-field/m-p/62926#M788446 <HTML><HEAD></HEAD><BODY><P>You have two options</P><P></P><P>1) Use OnAnySelect trigger</P><P>2) Field Event Triggers</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/194040_Capture.PNG" style="height: 540px; width: 620px;" /></P></BODY></HTML> Wed, 21 Feb 2018 12:33:24 GMT https://community.qlik.com/t5/QlikView/select-same-value-in-other-field/m-p/62926#M788446 sunny_talwar 2018-02-21T12:33:24Z Re: select same value in other field https://community.qlik.com/t5/QlikView/select-same-value-in-other-field/m-p/62927#M788447 <HTML><HEAD></HEAD><BODY><P><IMG alt="Voorbeeld.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/194038_Voorbeeld.png" style="width: 620px; height: 496px;" />Arikel.Code must change with value of field Component . What is my Search string ?</P></BODY></HTML> Wed, 21 Feb 2018 12:46:19 GMT https://community.qlik.com/t5/QlikView/select-same-value-in-other-field/m-p/62927#M788447 francisvandergr 2018-02-21T12:46:19Z Re: select same value in other field https://community.qlik.com/t5/QlikView/select-same-value-in-other-field/m-p/62928#M788448 <HTML><HEAD></HEAD><BODY><P>Try like this</P><P></P><P><STRONG>=If(GetSelectedCount(Field2) &gt;0, '(' &amp; Concat(DISTINCT '"' &amp; Field2 &amp; '"', '|') &amp; ')')</STRONG></P></BODY></HTML> Wed, 21 Feb 2018 12:49:49 GMT https://community.qlik.com/t5/QlikView/select-same-value-in-other-field/m-p/62928#M788448 sunny_talwar 2018-02-21T12:49:49Z