Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count Selected Multiple selection box

Hello,

I want to count the number of selected values in a multiple selection box.

How can i do this?

Thx in advance

1 Solution

Accepted Solutions
swuehl
MVP
MVP

You can look into GetSelectedCount( YourField ) to get the number of selected values in a field, or

Rangesum(SubStringCount( GetCurrentSelections(),':')) to get the number of fields with selections.

View solution in original post

2 Replies
swuehl
MVP
MVP

You can look into GetSelectedCount( YourField ) to get the number of selected values in a field, or

Rangesum(SubStringCount( GetCurrentSelections(),':')) to get the number of fields with selections.

maxgro
MVP
MVP

multi box?

if you have Field1/2/3

=rangesum(GetSelectedCount(Field1), GetSelectedCount(Field2), GetSelectedCount(Field3))

but I don't understand the purpose (or maybe I don't understand the question)