topic Re: Get the second value of the current selection in QlikView https://community.qlik.com/t5/QlikView/Get-the-second-value-of-the-current-selection/m-p/1249223#M871506 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>use following expression :</P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=SubField(GetFieldSelections(Customer),',',-1)</STRONG></P></BODY></HTML> Tue, 15 Nov 2016 05:36:43 GMT Anonymous 2016-11-15T05:36:43Z Get the second value of the current selection https://community.qlik.com/t5/QlikView/Get-the-second-value-of-the-current-selection/m-p/1249218#M871501 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Does anyone know how to get the second value of the current selection?</P><P></P><P>For example I have a field Customer and currently the following customer have been selected:</P><P></P><P>1. <SPAN style="font-size: 10pt;">John</SPAN></P><P><SPAN style="font-size: 10pt;">2. Peter.</SPAN></P><P></P><P>Does anyone know how to pick the second selection.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Get-the-second-value-of-the-current-selection/m-p/1249218#M871501 2020-11-25T16:16:04Z Re: Get the second value of the current selection https://community.qlik.com/t5/QlikView/Get-the-second-value-of-the-current-selection/m-p/1249219#M871502 <HTML><HEAD></HEAD><BODY><P>Try like this:</P><P>Textbetween(GetFieldSelections(Customer),',','') </P></BODY></HTML> Mon, 14 Nov 2016 21:36:40 GMT https://community.qlik.com/t5/QlikView/Get-the-second-value-of-the-current-selection/m-p/1249219#M871502 robert_mika 2016-11-14T21:36:40Z Re: Get the second value of the current selection https://community.qlik.com/t5/QlikView/Get-the-second-value-of-the-current-selection/m-p/1249220#M871503 <HTML><HEAD></HEAD><BODY><P>May be as below:</P><P></P><P>=SubField(GetFieldSelections(Customer),',',2)</P></BODY></HTML> Tue, 15 Nov 2016 02:10:52 GMT https://community.qlik.com/t5/QlikView/Get-the-second-value-of-the-current-selection/m-p/1249220#M871503 trdandamudi 2016-11-15T02:10:52Z Re: Get the second value of the current selection https://community.qlik.com/t5/QlikView/Get-the-second-value-of-the-current-selection/m-p/1249221#M871504 <HTML><HEAD></HEAD><BODY><P>Thirumala,</P><P></P><P>If we select 3 Items from Selectors, Then the above expression shows still 2nd Value only</P><P></P><P>Do you mean this?</P><P></P><P><STRONG>=SubField(GetFieldSelections(Customer),',',-1)</STRONG></P></BODY></HTML> Tue, 15 Nov 2016 02:52:33 GMT https://community.qlik.com/t5/QlikView/Get-the-second-value-of-the-current-selection/m-p/1249221#M871504 Anil_Babu_Samineni 2016-11-15T02:52:33Z Re: Get the second value of the current selection https://community.qlik.com/t5/QlikView/Get-the-second-value-of-the-current-selection/m-p/1249222#M871505 <HTML><HEAD></HEAD><BODY><P>No anil. for your expression its giving last selected value. small change in your expression</P><P><STRONG>=SubField(GetFieldSelections(key),',',-2) </STRONG></P><P><STRONG><IMG alt="te.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143894_te.PNG" style="height: 229px; width: 620px;" /></STRONG><IMG alt="al.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/143895_al.PNG" style="height: 254px; width: 620px;" /></P></BODY></HTML> Tue, 15 Nov 2016 04:32:27 GMT https://community.qlik.com/t5/QlikView/Get-the-second-value-of-the-current-selection/m-p/1249222#M871505 Chanty4u 2016-11-15T04:32:27Z Re: Get the second value of the current selection https://community.qlik.com/t5/QlikView/Get-the-second-value-of-the-current-selection/m-p/1249223#M871506 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>use following expression :</P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=SubField(GetFieldSelections(Customer),',',-1)</STRONG></P></BODY></HTML> Tue, 15 Nov 2016 05:36:43 GMT https://community.qlik.com/t5/QlikView/Get-the-second-value-of-the-current-selection/m-p/1249223#M871506 Anonymous 2016-11-15T05:36:43Z