topic Re: How to trim my 'GetCurrentSelections' results in QlikView https://community.qlik.com/t5/QlikView/How-to-trim-my-GetCurrentSelections-results/m-p/1028970#M1294883 <HTML><HEAD></HEAD><BODY><P>Great, I am glad we were able to help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>If you got what you were looking for, I would suggest closing the thread by marking correct and useful answers.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 07 Jan 2016 09:49:27 GMT sunny_talwar 2016-01-07T09:49:27Z How to trim my 'GetCurrentSelections' results https://community.qlik.com/t5/QlikView/How-to-trim-my-GetCurrentSelections-results/m-p/1028965#M1294873 <HTML><HEAD></HEAD><BODY><P>Hello:</P><P></P><P>Does anybody know how to display all the the Current Selections? When I select several elements of the same variable, the GetCurrentSelections function returns the number of elements selected but not a list as if I had selected one element.</P><P></P><P>For instance:</P><P>GetCurrentSelections return:</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Brand: 5 of 129</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">And I would like to have diplayed:</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Brand: A, B, C, D, E</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Thank you very much in advance,<BR /></SPAN></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/How-to-trim-my-GetCurrentSelections-results/m-p/1028965#M1294873 2026-01-26T18:19:17Z Re: How to trim my 'GetCurrentSelections' results https://community.qlik.com/t5/QlikView/How-to-trim-my-GetCurrentSelections-results/m-p/1028966#M1294876 <HTML><HEAD></HEAD><BODY><P>Hi Jose, you can try with:</P><P>Concat(Distinct Brand, ', ')</P><P></P><P>or</P><P>Concat(Distinct Brand, ',') // If you don't want space after the comma</P></BODY></HTML> Tue, 05 Jan 2016 16:33:04 GMT https://community.qlik.com/t5/QlikView/How-to-trim-my-GetCurrentSelections-results/m-p/1028966#M1294876 rubenmarin 2016-01-05T16:33:04Z Re: How to trim my 'GetCurrentSelections' results https://community.qlik.com/t5/QlikView/How-to-trim-my-GetCurrentSelections-results/m-p/1028967#M1294878 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG style="text-decoration: line-through;">GetCurrentSelections(Brand, ', ', 10000)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><STRONG style="font-size: 13.3333px;">GetFieldSelections(Brand, ', ', 10000)</STRONG></STRONG></P></BODY></HTML> Tue, 05 Jan 2016 16:37:03 GMT https://community.qlik.com/t5/QlikView/How-to-trim-my-GetCurrentSelections-results/m-p/1028967#M1294878 sunny_talwar 2016-01-05T16:37:03Z Re: How to trim my 'GetCurrentSelections' results https://community.qlik.com/t5/QlikView/How-to-trim-my-GetCurrentSelections-results/m-p/1028968#M1294881 <HTML><HEAD></HEAD><BODY><P>Hi Jose,</P><P></P><P>you can use sunny Expression.That works better.</P><P></P><P></P><P></P><P>-Nagarjuna</P></BODY></HTML> Tue, 05 Jan 2016 16:42:22 GMT https://community.qlik.com/t5/QlikView/How-to-trim-my-GetCurrentSelections-results/m-p/1028968#M1294881 nagarjuna_kotha 2016-01-05T16:42:22Z Re: How to trim my 'GetCurrentSelections' results https://community.qlik.com/t5/QlikView/How-to-trim-my-GetCurrentSelections-results/m-p/1028969#M1294882 <HTML><HEAD></HEAD><BODY><P>Thank you very much guys!</P><P></P><P>Sunny, your solution runs fine!</P><P>Ruben, thank you for your help!</P></BODY></HTML> Thu, 07 Jan 2016 09:35:14 GMT https://community.qlik.com/t5/QlikView/How-to-trim-my-GetCurrentSelections-results/m-p/1028969#M1294882 2016-01-07T09:35:14Z Re: How to trim my 'GetCurrentSelections' results https://community.qlik.com/t5/QlikView/How-to-trim-my-GetCurrentSelections-results/m-p/1028970#M1294883 <HTML><HEAD></HEAD><BODY><P>Great, I am glad we were able to help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>If you got what you were looking for, I would suggest closing the thread by marking correct and useful answers.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 07 Jan 2016 09:49:27 GMT https://community.qlik.com/t5/QlikView/How-to-trim-my-GetCurrentSelections-results/m-p/1028970#M1294883 sunny_talwar 2016-01-07T09:49:27Z