Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

georgina_spary
New 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
mov
Esteemed Contributor III

Matching several values in Set analysis

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
mov
Esteemed Contributor III

Matching several values in Set analysis

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