Set Analysis question

[#1]

Hi,

   I have a chart either pivot table or straight table. now i need  to create a  column which should do count of selections made. Example if i make selection on one list box the count should be  one , if the selcitions are two then one more row should add in that column as  two.

the values should dynamically increase in that column as per the selections made.

Do respond me with set analysis expression

[#2]

If the list box is one, try to use

=getselectedcount(Field)

as expression of column,where field is the field of list box.

[#3 · Accepted solution]

Hi,

     Mario thanks for your quick and sharp response, but what if we make sections in more than one list boxes

[#4]

=getselectedcount(field1) + getselectedcount(field2) + ...

Try this?

[preminqlik]

=getselectedcount(field1)+getselectedcount(field2)+getselectedcount(field3)+.....

[#6]

Hi Jacob,

  It works fine

[#7]

try this:

=SubStringCount( GetCurrentSelections(' | ', '::', '::'),'::')