GetSelectedCount() finds the number of selected (green) values in a field.
Syntax:
GetSelectedCount (field_name [, include_excluded])
Return data type: integer
Arguments:
| Arguments | Description |
|---|---|
| field_name | The field containing the range of data to be measured. |
| include_excluded | If set to 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 and results:
The following example uses three fields loaded to different filter panes, one for First name name, one for Initials and one for Has cellphone.
| Examples | Results |
|---|---|
|
Given that John is selected in First name. GetSelectedCount ([First name]) |
1 as one value is selected in First name. |
|
Given that John is selected in First name. GetSelectedCount ([Initials]) |
0 as no values are selected in Initials. |
|
With no selections in .First name, select all values in Initials and after that select the value Yes in Has cellphone. GetSelectedCount ([Initials]) |
6. Although selections with InitialsMC and PD have Has cellphone set to No, the result is still 6, because the argument include_excluded is set to True(). |
Data used in example:
Initials:
LOAD * inline [
"First name"|Initials|"Has cellphone"
John|JA|Yes
Sue|SB|Yes
Mark|MC |No
Peter|PD|No
Jane|JE|Yes
Peter|PF|Yes ] (delimiter is '|');