These functions can only be used in chart expressions.
Field functions either return integers or strings identifying different aspects of field selections.
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
Count functions
GetSelectedCount() finds the number of selected (green) values in a field.
GetPossibleCount() is used to find the number of possible (white) values in the identified field. If the identified field includes selections, then the selected (green) fields are also counted.
GetExcludedCount() finds the number of excluded distinct values in the identified field. Only excluded (gray cell with white text) values are counted. Alternative (white cell with gray text) and selected excluded (gray cell with green text) values are not counted.
This chart function returns the number of not-selected (red cell with black text) values
in the field named fieldname.
The field must be in and-mode for this function to be relevant.
Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com