Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
carolin01
Luminary Alumni
Luminary Alumni

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

1 Solution

Accepted Solutions
dirk_konings
Creator III
Creator III

it should be : GetSelectedCount(SoldToBusinessPartner) < 1

she want's to use it as a calculation condition

View solution in original post

10 Replies
Not applicable

Try...

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

alexandros17
Partner - Champion III
Partner - Champion III

Try to use getpossiblecount()

Not applicable

Hi,

Try this

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

Regards

Kumar

perumal_41
Partner - Specialist II
Partner - Specialist II

Hi

Try

 

getalternativecount ( REGION )


dirk_konings
Creator III
Creator III

it should be : GetSelectedCount(SoldToBusinessPartner) < 1

she want's to use it as a calculation condition

carolin01
Luminary Alumni
Luminary Alumni
Author

Perfect - thank you for your help and all the responses

carolin01
Luminary Alumni
Luminary Alumni
Author

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?

dirk_konings
Creator III
Creator III

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

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

carolin01
Luminary Alumni
Luminary Alumni
Author

Perfect, Thank you !!!