topic Re: Count number of values selected in QlikView https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718738#M1062981 <HTML><HEAD></HEAD><BODY><P>GetSelectedCount is the function you are searching.</P><P></P><P class="syntax"><A name="kanchor283"></A><A name="getselectedcount"></A><SPAN class="Bold">getselectedcount(</SPAN><SPAN class="Italic">NombredeCampo [, IncluirExcluidos]</SPAN><SPAN class="Bold">)</SPAN> </P></BODY></HTML> Wed, 17 Sep 2014 10:10:53 GMT rubenmarin 2014-09-17T10:10:53Z Count number of values selected https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718736#M1062979 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a selection field that shows the months (Jan - Dec).</P><P></P><P>I would like to find out, how many months have been selected.</P><P></P><P>If I use 'Count(Distinct Month)' then I do get the number of selected months, but I also get 12 if there is no month selected. How can I adjust the count to find out if there are none selected?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 17 Sep 2014 10:08:06 GMT https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718736#M1062979 2014-09-17T10:08:06Z Re: Count number of values selected https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718737#M1062980 <HTML><HEAD></HEAD><BODY><P>use GetSelectedCount() function.</P></BODY></HTML> Wed, 17 Sep 2014 10:09:50 GMT https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718737#M1062980 senpradip007 2014-09-17T10:09:50Z Re: Count number of values selected https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718738#M1062981 <HTML><HEAD></HEAD><BODY><P>GetSelectedCount is the function you are searching.</P><P></P><P class="syntax"><A name="kanchor283"></A><A name="getselectedcount"></A><SPAN class="Bold">getselectedcount(</SPAN><SPAN class="Italic">NombredeCampo [, IncluirExcluidos]</SPAN><SPAN class="Bold">)</SPAN> </P></BODY></HTML> Wed, 17 Sep 2014 10:10:53 GMT https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718738#M1062981 rubenmarin 2014-09-17T10:10:53Z Re: Count number of values selected https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718739#M1062982 <HTML><HEAD></HEAD><BODY><P>=GetSelectedCount(months)</P></BODY></HTML> Wed, 17 Sep 2014 10:12:25 GMT https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718739#M1062982 MK_QSL 2014-09-17T10:12:25Z Re: Count number of values selected https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718740#M1062983 <HTML><HEAD></HEAD><BODY><P>=GetSelectedCount(Month)</P></BODY></HTML> Wed, 17 Sep 2014 10:12:47 GMT https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718740#M1062983 anbu1984 2014-09-17T10:12:47Z Re: Count number of values selected https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718741#M1062984 <HTML><HEAD></HEAD><BODY><P>Month<SPAN style="font-size: 8pt;"> &amp; '( ' &amp; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">GetSelectedCount</SPAN><SPAN style="font-size: 8pt;">( </SPAN><SPAN style="color: #800000; font-size: 8pt;">Month</SPAN><SPAN style="font-size: 8pt;">) &amp; ')'&nbsp; will give you count of selected Months</SPAN></P><P><SPAN style="font-size: 8pt;">Regards</SPAN></P><P><SPAN style="font-size: 8pt;">Chaitanya</SPAN></P><P></P></BODY></HTML> Wed, 17 Sep 2014 10:16:03 GMT https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718741#M1062984 ychaitanya 2014-09-17T10:16:03Z Re: Count number of values selected https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718742#M1062985 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use GetSelectedCount(Month)</P><P></P><P>Logically when no month is selected then you are getting data of all months therefore It means you have all available month to count.</P><P>So try GetSelectedCount() instead of count(Distinct Month)</P><P></P><P>Regards</P></BODY></HTML> Wed, 17 Sep 2014 10:16:13 GMT https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718742#M1062985 PrashantSangle 2014-09-17T10:16:13Z Re: Count number of values selected https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718743#M1062986 <HTML><HEAD></HEAD><BODY><P>=GetSelectedCount(months)</P></BODY></HTML> Wed, 17 Sep 2014 10:34:03 GMT https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718743#M1062986 2014-09-17T10:34:03Z Re: Count number of values selected https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718744#M1062987 <HTML><HEAD></HEAD><BODY><P>Wow, thanks so much for all your replies <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 18 Sep 2014 01:41:56 GMT https://community.qlik.com/t5/QlikView/Count-number-of-values-selected/m-p/718744#M1062987 2014-09-18T01:41:56Z