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: 
georgina_spary
Contributor II
Contributor II

Matching several values in Set analysis

Hello folks. I've written some set analysis. This counts students only where the [Module Compulsory Prog] field matches a single [Programme Code] field selected.

= Sum ({$<[Module Compulsory Prog]={$(=[Programme Code])}>}[Student Count])

How can I get it to work when I select multiple [Programme Code] fields - i.e count students where [Module Compulsory Prog] matches any of a selection of [Programme Code] fields?

Thanks in advance

George

1 Solution

Accepted Solutions
Anonymous
Not applicable

This should work, no matter if you select one or many:

= Sum ({$<[Module Compulsory Prog]=P([Programme Code])>}[Student Count])

View solution in original post

1 Reply
Anonymous
Not applicable

This should work, no matter if you select one or many:

= Sum ({$<[Module Compulsory Prog]=P([Programme Code])>}[Student Count])