Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products.
All content is subject to change and is provided without warranty.
Skip to main content Skip to complementary content

GetPossibleCount - chart function

GetPossibleCount() is used to find the number of possible values in the identified field. If the identified field includes selections, then the selected (green) fields are counted. Otherwise associated (white) values are counted.

For fields with selections, GetPossibleCount() returns the number of selected (green) fields.

Syntax:  

GetPossibleCount (field_name)

Return data type: integer

Information note

The colors used in the selection bar, and for each selection state, can be modified with a custom theme. If you are working with an app that uses a custom theme, you might notice that your selections do not display with the same colors that are described in this help topic.

Arguments
Arguments Description
field_name The field containing the range of data to be measured.

The following table lists other functions that are related to this function.

Related functions
Function Interaction
GetStateCounts - chart function

Using GetStateCounts(), you can combine the calculation of the following counts using a single function call:

  • Count of selected included values.

  • Count of possible values.

  • Count of alternative values.

  • Count of excluded values, not including alternative and selected excluded values.

  • Count of selected excluded values.

GetSelectedCount - chart function Returns the count of selected included values.
GetAlternativeCount - chart function Returns the count of alternative values.
GetPossibleCount - chart function Returns the count of excluded values, not including alternative and selected excluded values.
Example: Chart expressions
Example Result
GetPossibleCount( Initials ) If no selections are made then it returns the total number of unique values in the field Initials. If one value in this field is selected then it returns 1. If a selection is made on another field then the value returned is the number of unique values in the Initials field that relate to the values selected in the second field.

Example - GetPossibleCount fundamentals

Example - GetPossibleCount scenario

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!