topic Get Number of Current Selections in QlikView https://community.qlik.com/t5/QlikView/Get-Number-of-Current-Selections/m-p/291145#M108064 <HTML><HEAD></HEAD><BODY><P>Do you mean selections in two different fields? If I don't miss anything more simple, this gives you the number of fields with selections in:</P><P>=if(len(GetCurrentSelections()),SubStringCount(GetCurrentSelections(),chr(13))+1,0)</P><P></P><P>If you mean selection within a field,you could use GetSelectedCount() function.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Mon, 22 Aug 2011 20:31:20 GMT swuehl 2011-08-22T20:31:20Z Get Number of Current Selections https://community.qlik.com/t5/QlikView/Get-Number-of-Current-Selections/m-p/291144#M108063 <HTML><HEAD></HEAD><BODY><P>I have a condition where I need to ensure at least 2 current selections have been made.&nbsp; Does anyone know how to get the number of current selections?</P></BODY></HTML> Mon, 22 Aug 2011 20:08:02 GMT https://community.qlik.com/t5/QlikView/Get-Number-of-Current-Selections/m-p/291144#M108063 2011-08-22T20:08:02Z Get Number of Current Selections https://community.qlik.com/t5/QlikView/Get-Number-of-Current-Selections/m-p/291145#M108064 <HTML><HEAD></HEAD><BODY><P>Do you mean selections in two different fields? If I don't miss anything more simple, this gives you the number of fields with selections in:</P><P>=if(len(GetCurrentSelections()),SubStringCount(GetCurrentSelections(),chr(13))+1,0)</P><P></P><P>If you mean selection within a field,you could use GetSelectedCount() function.</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Mon, 22 Aug 2011 20:31:20 GMT https://community.qlik.com/t5/QlikView/Get-Number-of-Current-Selections/m-p/291145#M108064 swuehl 2011-08-22T20:31:20Z Get Number of Current Selections https://community.qlik.com/t5/QlikView/Get-Number-of-Current-Selections/m-p/291146#M108065 <HTML><HEAD></HEAD><BODY><P>works! thanks!</P><P></P><P>I am using it in a button enable statement so I just cutout this part:</P><P>SubStringCount(GetCurrentSelections(),chr(13))</P></BODY></HTML> Mon, 22 Aug 2011 22:11:52 GMT https://community.qlik.com/t5/QlikView/Get-Number-of-Current-Selections/m-p/291146#M108065 2011-08-22T22:11:52Z Re: Get Number of Current Selections https://community.qlik.com/t5/QlikView/Get-Number-of-Current-Selections/m-p/291147#M108066 <HTML><HEAD></HEAD><BODY><P>I would reduce this to</P><P></P><P>=Alt(SubStringCount(GetCurrentSelections(), Chr(13)) + 1, 0)</P><P></P><P>so it doesn't have to GetCurrentSelections() twice. (and because I love Alt even more than Excel's IFERROR)</P></BODY></HTML> Wed, 28 Jun 2017 15:01:45 GMT https://community.qlik.com/t5/QlikView/Get-Number-of-Current-Selections/m-p/291147#M108066 brian554xx 2017-06-28T15:01:45Z