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