topic How to show several selected items in caption in QlikView https://community.qlik.com/t5/QlikView/How-to-show-several-selected-items-in-caption/m-p/741569#M536345 <HTML><HEAD></HEAD><BODY><P><BR />Hi ,</P><P></P><P>I have a pivot table named like the value selected in a list box , I simply wrote '=field_in_listbox' in the box 'Window title'.</P><P></P><P>But when I choose more than one value the title just shows '-'.</P><P></P><P>How could I make it to show all the selected values separated by comma for example?</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 13 Nov 2014 17:20:00 GMT 2014-11-13T17:20:00Z How to show several selected items in caption https://community.qlik.com/t5/QlikView/How-to-show-several-selected-items-in-caption/m-p/741569#M536345 <HTML><HEAD></HEAD><BODY><P><BR />Hi ,</P><P></P><P>I have a pivot table named like the value selected in a list box , I simply wrote '=field_in_listbox' in the box 'Window title'.</P><P></P><P>But when I choose more than one value the title just shows '-'.</P><P></P><P>How could I make it to show all the selected values separated by comma for example?</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 13 Nov 2014 17:20:00 GMT https://community.qlik.com/t5/QlikView/How-to-show-several-selected-items-in-caption/m-p/741569#M536345 2014-11-13T17:20:00Z Re: How to show several selected items in caption https://community.qlik.com/t5/QlikView/How-to-show-several-selected-items-in-caption/m-p/741570#M536346 <HTML><HEAD></HEAD><BODY><P>=concat(distinct [field_in_listbox], ', ')</P></BODY></HTML> Thu, 13 Nov 2014 17:34:28 GMT https://community.qlik.com/t5/QlikView/How-to-show-several-selected-items-in-caption/m-p/741570#M536346 Gysbert_Wassenaar 2014-11-13T17:34:28Z