Skip to main content Skip to complementary content

GetExcludedCount

GetExcludedCount() finds the number of excluded distinct values in the identified field. Excluded values include alternative (white or light yellow), excluded and selected excluded (gray) fields.

Syntax:  

GetExcludedCount (field_name)

Return data type: string

Arguments:  

  • field_name: The field containing the range of data to be measured.

Examples

The following example uses three fields loaded to different list boxes, one for First name , one for Last name, and one for Initials.

Example 1: no values selected in First name

GetExcludedCount (Initials) = 0

There are no selections.

Example 2: John selected in First name

GetExcludedCount (Initials) = 5

There are 5 excluded values in Initials with gray color. The sixth cell (JA) will be white as it is associated with the selection John in First name.

Example 3: John and Peter selected in First name

GetExcludedCount (Initials) = 3

John is associated with 1 value and Peter is associated with 2 values, in Initials.

Example 4: John and Peter selected in First name, Franc selected in Last name

GetExcludedCount ([First name]) = 4

There are 4 excluded values in First name with gray color. GetExcludedCount() evaluates for fields with excluded values, including alternative and selected excluded fields.

Example 5: John and Peter selected in First name, Franc and Andersonselected in Last name

GetExcludedCount (Initials) = 4

There are 4 excluded values in Initials with gray color. The other two cells (JA and PF) will be white or light yellow as they associated with the selections John and Peter in First name.

Example 6: John and Peter selected in First name, Franc and Anderson selected in Last name

GetExcludedCount ([Last name]) = 4

There are 4 excluded values in Initials. Devonshire, Brown, Carr, and Elliot have gray color.

Data used in example:

Names:

LOAD * inline [

"First name"|"Last name"|Initials|"Has cellphone"

John|Anderson|JA|Yes

Sue|Brown|SB|Yes

Mark|Carr|MC |No

Peter|Devonshire|PD|No

Jane|Elliot|JE|Yes

Peter|Franc|PF|Yes ] (delimiter is '|');

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com