Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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)