topic Re: Count Selected Multiple selection box in QlikView

Count Selected Multiple selection box

Tue, 27 Oct 2015 19:45:55 GMT

Hello,

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

How can i do this?

Thx in advance

swuehl — Tue, 27 Oct 2015 19:59:15 GMT

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 — Tue, 27 Oct 2015 20:03:04 GMT

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)