How to determine if 1 or more selection(s) lead(s) to 1 final result?

[MrBosch]

Hi all,

I have been searching for the obvious but can find it. Perhaps it is a no-brainer...
Assume this is my data set:

Code	Last Name	First Name	Company
h&fg&Vh8	Doe	John	ABC
kHYvG86X	Doe	Lex	DEF
PhYvF4@f	Radclife	John	ABC

It is obvious that Code is unique. I can show/hide a text box (with all the personal data from the other fields) in a conditional show whenever I have selected one unique Code. =GetSelectedCount(Code)=1

But when I start with no selections, then click Doe then click ABC there will be only one result left. Now I want this text box to show. I cannot test on GetSelectedCount (xx)=1 since I don't know which selections have resulted in the final 1 remaining 'row'.

If I had to create my own function in Qlik it would have been (and I hope it explains what I am looking for):
=If(NumberOfFinalResultsAfterSomeSelections=1),1,0)

So it will only show objects when I have narrowed the selection down to this 'last man standing'. 

Thanks for any help.

[rubenmarin · Accepted solution]

Hi, there is a GetPossibleCount() function. Similar to GetSelctedCount() but in this case it doesn't matter where the selctions were done.

You can also use: Count(DISTINCT Code)=1

[MrBosch]

Thank you so much Rubenmarin,

For others:
I have implemented Rubenmarins solution into the Layout of this TextBox

=if(GetPossibleCount(SomeFieldofYours)=1,1,0)

and it works like a charm!