Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

What does GetSelectedCount function do?

I tried googling it but didn't see a straight answer.

Thanks

A

1 Solution

Accepted Solutions
MVP
MVP

Re: What does GetSelectedCount function do?

From Help:

getselectedcount (FieldName [,IncludeExcluded])

Returns the current number of selected values in a field.

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.

Examples

getselectedcount ( Year )

getselectedcount ( Year, true( ) )

Note: it's better to go to Help or Qlikview Reference Manual before googling for qlikview basic help.

6 Replies
MVP
MVP

Re: What does GetSelectedCount function do?

From Help:

getselectedcount (FieldName [,IncludeExcluded])

Returns the current number of selected values in a field.

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.

Examples

getselectedcount ( Year )

getselectedcount ( Year, true( ) )

Note: it's better to go to Help or Qlikview Reference Manual before googling for qlikview basic help.

Re: What does GetSelectedCount function do?

Instead of Googling First you check with Help file provided by Qlikview which has descriptions for all the functions.

If you cannot understand the description provided you can search the QlikCommunity.

Not applicable

Re: What does GetSelectedCount function do?

The GetSelectedCount() function, returns the current number of selected values in the specified field. 


Not applicable

Re: What does GetSelectedCount function do?

Thank you!

Not applicable

Re: What does GetSelectedCount function do?

Hi tresesco,

Is this function is applied to the calculated fields in the application?

rakeshkumar1890
New Contributor III

Re: What does GetSelectedCount function do?

Absolutely correct Juan says Returns the current number of selected values in the specified field

for example if you want in the sheet load the calculation after any selection

then you can use conditionally open the sheet.

=If(GetSelectedCount(FieldName)>0,1,0)

Community Browser