Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
karthick01
Contributor III
Contributor III

GetNotSelectedCount with example

Can someone explain GetNotSelectedCount with example. Please do not copy paste the definition from the Qlikvew help. I do not understand from that definition

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

hi,

chk dis

GetNotSelectedCount

This chart function returns the number of not-selected values in the field named fieldname. The field must be in and-mode for this function to be relevant.

Syntax:

GetNotSelectedCount ( field_name [, include_excluded])

(Inherited)GetNotSelectedCount ( FieldName [, IncludeExcluded])

Arguments:

ArgumentsDescription
field_nameThe field containing the range of data to be measured.
include_excludedIf 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.

Example:

GetNotSelectedCount ( Year ) 

GetNotSelectedCount (Year,True())

Not.PNG

View solution in original post

4 Replies
Chanty4u
MVP
MVP

hi,

chk dis

GetNotSelectedCount

This chart function returns the number of not-selected values in the field named fieldname. The field must be in and-mode for this function to be relevant.

Syntax:

GetNotSelectedCount ( field_name [, include_excluded])

(Inherited)GetNotSelectedCount ( FieldName [, IncludeExcluded])

Arguments:

ArgumentsDescription
field_nameThe field containing the range of data to be measured.
include_excludedIf 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.

Example:

GetNotSelectedCount ( Year ) 

GetNotSelectedCount (Year,True())

Not.PNG

swuehl
MVP
MVP

As the HELP indicates, the function is only really useful if a listbox is in AND mode.

I guess you already have ooked into AND mode to understand the mode and the GetNotSelectedCount functions, haven't you?

AND and OR

Read also Jenny's blog post and download the zip with the sample QVW here:

AND-Mode

Open the QVW, there is already a selection in the AND mode list box.

Without changing the selection, create a textbox with

=GetSelectedCount([Product Sub Group ANDMode])

and another with

=GetNotSelectedCount([Product Sub Group ANDMode])

It should be more than clear what both number indicate when looking at the list box and after reading above docs.

Regards,

Stefan

karthick01
Contributor III
Contributor III
Author

Thanks for your help guys

swuehl
MVP
MVP

Your welcome!

(And it seems like you've understood the Help, so next time I can also just copy & paste )