Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
carolin01
Partner - Creator II
Partner - Creator II

GetNotSelectedCount

Hello,

I´m trying use a condition for an expression in my chart. I would like to exclude that expression as soon as a selection is done in the field SoldToBusinessPartner. I tried it with

GetNotSelectedCount (SoldToBusinessPartner, true)  and GetNotSelectedCount (SoldToBusinessPartner

This doesn´t work. Does anybody have any other ideas?

Many thanks in advance.

Best regards

Carolin

10 Replies
Not applicable

I assumed GetNotSelectedCount would be like the "inverse" of GetSelectedCount,

That is, when one is 0, the other is not, and vice versa.

But after reading the documentation, I realize there is a

  1. second parameter "IncludeExcluded" (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)
  2. and a requirement: "The field must be in and-mode for this function to be relevant."

Which makes me sure of one thing: I don't know exactly how this function works, or where I would use this function!