topic Re: GetNotSelectedCount in QlikView

GetNotSelectedCount

carolin01 — Thu, 13 Mar 2014 10:30:48 GMT

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

Re: GetNotSelectedCount

Thu, 13 Mar 2014 10:33:02 GMT

Try...

GetNotSelectedCount (SoldToBusinessPartner, true()) and GetNotSelectedCount (SoldToBusinessPartner)

Re: GetNotSelectedCount

alexandros17 — Thu, 13 Mar 2014 10:33:48 GMT

Try to use getpossiblecount()

Re: GetNotSelectedCount

Thu, 13 Mar 2014 11:41:01 GMT

Hi,

Try this

=Count({1}Distinct SoldToBusinessPartner)-GetSelectedCount(SoldToBusinessPartner)

Regards

Kumar

Re: GetNotSelectedCount

perumal_41 — Thu, 13 Mar 2014 12:12:58 GMT

Try

getalternativecount ( REGION )

Re: GetNotSelectedCount

dirk_konings — Thu, 13 Mar 2014 12:29:16 GMT

it should be : GetSelectedCount(SoldToBusinessPartner) < 1

she want's to use it as a calculation condition

Re: GetNotSelectedCount

carolin01 — Thu, 13 Mar 2014 12:45:44 GMT

Perfect - thank you for your help and all the responses

Re: GetNotSelectedCount

carolin01 — Thu, 13 Mar 2014 13:24:57 GMT

I´m having the next issue in another chart. Here I would like to create a mutiple getselectedcount statement and tried:

GetSelectedCount(ExternalSalesRep2 or GeneralManagerName or AreaSalesManagerName or TypeOfSalesRep, true)

This should be a condition for a field and the field should only be shown if one ore more values are selected in the fields ExternalSalesRep2, GeneralManagerName, AreaSalesManagerName or TypeOfSalesRep. Do you have an idea how to do this?

Re: GetNotSelectedCount

dirk_konings — Thu, 13 Mar 2014 13:27:53 GMT

getselectedcount(field1) + getselectedcount(field2) + .... > 0

in at least 1 of these fields a selection is made.

Re: GetNotSelectedCount

carolin01 — Thu, 13 Mar 2014 13:32:25 GMT

Perfect, Thank you !!!

Re: GetNotSelectedCount

Fri, 22 Jan 2016 22:46:19 GMT

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

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