Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
PGeorge
Contributor III
Contributor III

Ignore Selections using set analysis

Hello,

I have created the below expression in a bar chart measure and the set analysis ignoring the "HospitalName" doesn't seem to work. Even when I replace {$<[HospitalName]=>} with {1} my selections are still taken into account. In other  charts, I have created simpler expressions using the above set analysis and it works as expected. Is there something i am missing here?

=Aggr(Count({$<[HospitalName]=>} if((HandHygieneRecordsMapped.Action = 0 OR HandHygieneRecordsMapped.Action = 1) ,[HandHygieneRecordsMapped.Id])), [HospitalName])/Aggr(Count({$<[HospitalName]=>} [HandHygieneRecordsMapped.Id]), [HospitalName])

 

Thanks .

Labels (2)
10 Replies
PGeorge
Contributor III
Contributor III
Author

Thanks for you answer BrunPierre. 

The expression you provided was one of my former approaches which didn't work, as it recalculates every bar in the chart to 100%.