Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone explain GetNotSelectedCount with example. Please do not copy paste the definition from the Qlikvew help. I do not understand from that definition
hi,
chk dis
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())
hi,
chk dis
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())
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?
Read also Jenny's blog post and download the zip with the sample QVW here:
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
Thanks for your help guys
Your welcome!
(And it seems like you've understood the Help, so next time I can also just copy & paste )