topic Re: GetNotSelectedCount with example in QlikView

GetNotSelectedCount with example

Anonymous — Sat, 02 Apr 2016 03:19:26 GMT

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

Re: GetNotSelectedCount with example

Chanty4u — Sat, 02 Apr 2016 10:15:30 GMT

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())

Re: GetNotSelectedCount with example

swuehl — Sat, 02 Apr 2016 10:22:15 GMT

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

Re: GetNotSelectedCount with example

Anonymous — Tue, 05 Apr 2016 00:21:14 GMT

Thanks for your help guys

Re: GetNotSelectedCount with example

swuehl — Tue, 05 Apr 2016 16:48:57 GMT

Your welcome!

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