GetNotSelectedCount with example

[Anonymous]

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

[Chanty4u · Accepted solution]

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:

Arguments	Description
field_name	The field containing the range of data to be measured.
include_excluded	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.

Example:

GetNotSelectedCount ( Year ) 

GetNotSelectedCount (Year,True())

[swuehl]

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

[Anonymous]

Thanks for your help guys

[swuehl]

Your welcome!

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