topic Re: GetSelectedCount in QlikView

GetSelectedCount

Anonymous — Sun, 26 Jul 2015 16:01:07 GMT

Hi,

I hear that the function GetSelectedCount (in the latest QV version) is able to take the alternate state as an argument.

If so then what syntax is needed?

The standard syntax 'GetSelectedCount({AS} FieldName)' doesn't work.

Thank you in advance,

larisa

Re: GetSelectedCount

robert_mika — Sun, 26 Jul 2015 16:05:51 GMT

This function will only works in front end

like this(from help)

getselectedcount (FieldName [, IncludeExcluded [, State]])

Returns the current number of selected values in a field. It is possible to query an alternate state.

If IncludeExcluded is true the count will include selected values, which are currently excluded by selections in other fields. If false or omitted these values will not be included.

State is the alternate state to query.

Feeling Qlikngry?

How To /Missing Manual(18 articles)

Re: GetSelectedCount

antoniotiman — Sun, 26 Jul 2015 16:35:56 GMT

Hi Larisa,

Robert is right, but since QV 11.20 SR8.

You remember, Concat() and Count() functions support Alternate State.

Regards,

Antonio

Re: GetSelectedCount

Anonymous — Sun, 26 Jul 2015 16:46:43 GMT

Hi,

I've experimented with this formula. Now I see how the first part of it works.

1) getselectedcount (Brands, Var_IncludeExcluded=1)

2) getselectedcount (Brands, Var_IncludeExcluded=0)

These two variants resulted in the different figures according to the value of the variable Var_IncludeExcluded.

But I still don't see how I should add alternate state to this formula.

If I type brackets [] as you explained above, then QV considers the syntax to be wrong.

Could you please clarify?

The alternate state name is AS.

How should I add it to the formula: 'getselectedcount (Brands, Var_IncludeExcluded=0)'?

Re: GetSelectedCount

maxgro — Sun, 26 Jul 2015 16:54:54 GMT

maybe

=GetSelectedCount(FieldName, 0, 'AS')

Re: GetSelectedCount

Anonymous — Sun, 26 Jul 2015 16:58:07 GMT

Thank you! It works.