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

What does GetSelectedCount function do?

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

Thanks

A

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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.

View solution in original post

7 Replies
tresesco
MVP
MVP

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.

CELAMBARASAN
Partner - Champion
Partner - Champion

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
Author

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


Not applicable
Author

Thank you!

Not applicable
Author

Hi tresesco,

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

rakeshkumar1890
Creator
Creator

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)

Nixi80
Contributor
Contributor

Good Morning Everybody.

I have a similar problem with the function GetSelectedCount.

I would like to know if getselectedcount ([PRSC.flg_qts], true(), [PRSC.flg_qts]={'DELTA'}) can give the number 0 or 1 if I count the value 'DELTA' or not.

Hoping to have been clear.

 

Thanks