Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
nira
Contributor III
Contributor III

Set analysis to ignore current selection

Hi, i have an expression below:

=count({<org_name -= {GetFieldSelections(org_name)}>}patient_region)

In this I am trying to insert a set analysis to ignore the current selection made on the [org_name] field. I keep getting an error. What is the proper expression for it?

Thanks in advance!

5 Replies
albertovarela
Partner - Specialist
Partner - Specialist

Try: count({$<org_name =-{$(=Getfieldselections(org_name ))}>}patient_region)

anat
Master
Master

you can bypass the fields which selections don't want to impact in expression.

=count({<org_name=>}patient_region)

nira
Contributor III
Contributor III
Author

I keep getting an error message in the expression

nira
Contributor III
Contributor III
Author

Yeah, that's a possibility if the org_name I want to ignore is fixed, however, this value keeps changing based on the selections made which is why I am trying to use the GetFieldSelections() expression.

albertovarela
Partner - Specialist
Partner - Specialist

Here's a different approach

If(GetSelectedCount(org_name)=0
     ,count(patient_region)
     ,count({$<org_name=E(org_name)>}patient_region)
)