topic Re: Show Number and selected value in a listbox in QlikView https://community.qlik.com/t5/QlikView/Show-Number-and-selected-value-in-a-listbox/m-p/80325#M781446 <HTML><HEAD></HEAD><BODY><P>In a text box object, you can try this</P><P></P><P><STRONG>='Selected values: ' &amp; Concat(DISTINCT FieldName, ', ') &amp; ' and Selected No: ' &amp; Count(DISTINCT FieldName)</STRONG></P></BODY></HTML> Fri, 23 Mar 2018 15:45:35 GMT sunny_talwar 2018-03-23T15:45:35Z Show Number and selected value in a listbox https://community.qlik.com/t5/QlikView/Show-Number-and-selected-value-in-a-listbox/m-p/80324#M781445 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Hi,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>Could someone help with below requirement.</P><P>I need to show selected value and also how many values are selected in a listbox</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Ex: Selected values : In,US,UK and Selected No: 3</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Show-Number-and-selected-value-in-a-listbox/m-p/80324#M781445 suren946 2020-11-25T16:16:04Z Re: Show Number and selected value in a listbox https://community.qlik.com/t5/QlikView/Show-Number-and-selected-value-in-a-listbox/m-p/80325#M781446 <HTML><HEAD></HEAD><BODY><P>In a text box object, you can try this</P><P></P><P><STRONG>='Selected values: ' &amp; Concat(DISTINCT FieldName, ', ') &amp; ' and Selected No: ' &amp; Count(DISTINCT FieldName)</STRONG></P></BODY></HTML> Fri, 23 Mar 2018 15:45:35 GMT https://community.qlik.com/t5/QlikView/Show-Number-and-selected-value-in-a-listbox/m-p/80325#M781446 sunny_talwar 2018-03-23T15:45:35Z Re: Show Number and selected value in a listbox https://community.qlik.com/t5/QlikView/Show-Number-and-selected-value-in-a-listbox/m-p/80326#M781447 <HTML><HEAD></HEAD><BODY><P>Try concat function.</P><P></P><P>syntax : Concat(DISTINCT Year,',')</P></BODY></HTML> Fri, 23 Mar 2018 16:32:29 GMT https://community.qlik.com/t5/QlikView/Show-Number-and-selected-value-in-a-listbox/m-p/80326#M781447 shiveshsingh 2018-03-23T16:32:29Z Re: Show Number and selected value in a listbox https://community.qlik.com/t5/QlikView/Show-Number-and-selected-value-in-a-listbox/m-p/80327#M781448 <HTML><HEAD></HEAD><BODY><P>Thank You Sunny&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> your expression helped me </P><P></P><P>Also below expression gave me the expected output with slight difference in the output</P><P></P><P>='Selected Value: ' &amp; GetFieldSelections(Field) &amp;' '&amp; 'Selected No:' &amp;GetSelectedCount(Field)</P></BODY></HTML> Fri, 23 Mar 2018 21:47:31 GMT https://community.qlik.com/t5/QlikView/Show-Number-and-selected-value-in-a-listbox/m-p/80327#M781448 suren946 2018-03-23T21:47:31Z