topic Re: What does GetSelectedCount function do? in QlikView

What does GetSelectedCount function do?

Wed, 16 Oct 2013 07:51:12 GMT

I tried googling it but didn't see a straight answer.

Thanks

Re: What does GetSelectedCount function do?

tresB — Wed, 16 Oct 2013 07:55:35 GMT

From Help:

getselectedcount (FieldName [,IncludeExcluded])

Returns the current number of selected values in a field.

If IncludeExcluded is true the count will include
selected values, which are currently excluded by selections in other fields. If
false or omitted these values will not be included.

Examples

getselectedcount ( Year )

getselectedcount ( Year, true( ) )

Note: it's better to go to Help or Qlikview Reference Manual before googling for qlikview basic help.

Re: What does GetSelectedCount function do?

CELAMBARASAN — Wed, 16 Oct 2013 07:57:45 GMT

Instead of Googling First you check with Help file provided by Qlikview which has descriptions for all the functions.

If you cannot understand the description provided you can search the QlikCommunity.

Re: What does GetSelectedCount function do?

Wed, 16 Oct 2013 08:12:52 GMT

The GetSelectedCount() function, returns the current number of selected values in the specified field.

Re: What does GetSelectedCount function do?

Wed, 16 Oct 2013 08:14:44 GMT

Thank you!

Re: What does GetSelectedCount function do?

Mon, 13 Jan 2014 05:54:32 GMT

Hi tresesco,

Is this function is applied to the calculated fields in the application?

Re: What does GetSelectedCount function do?

rakeshkumar1890 — Sat, 03 Feb 2018 09:35:26 GMT

Absolutely correct Juan says Returns the current number of selected values in the specified field

for example if you want in the sheet load the calculation after any selection

then you can use conditionally open the sheet.

=If(GetSelectedCount(FieldName)>0,1,0)

Re: What does GetSelectedCount function do?

Nixi80 — Thu, 20 Aug 2020 12:57:38 GMT

Good Morning Everybody.

I have a similar problem with the function GetSelectedCount.

I would like to know if getselectedcount ([PRSC.flg_qts], true(), [PRSC.flg_qts]={'DELTA'}) can give the number 0 or 1 if I count the value 'DELTA' or not.

Hoping to have been clear.

Thanks