topic Matching several values in Set analysis in QlikView https://community.qlik.com/t5/QlikView/Matching-several-values-in-Set-analysis/m-p/315737#M497073 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>= Sum ({$&lt;[Module Compulsory Prog]={$(=[Programme Code])}&gt;}[Student Count])</P><P></P><P>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?</P><P></P><P>Thanks in advance</P><P></P><P>George</P></BODY></HTML> Wed, 05 Oct 2011 18:45:39 GMT georgina_spary 2011-10-05T18:45:39Z Matching several values in Set analysis https://community.qlik.com/t5/QlikView/Matching-several-values-in-Set-analysis/m-p/315737#M497073 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>= Sum ({$&lt;[Module Compulsory Prog]={$(=[Programme Code])}&gt;}[Student Count])</P><P></P><P>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?</P><P></P><P>Thanks in advance</P><P></P><P>George</P></BODY></HTML> Wed, 05 Oct 2011 18:45:39 GMT https://community.qlik.com/t5/QlikView/Matching-several-values-in-Set-analysis/m-p/315737#M497073 georgina_spary 2011-10-05T18:45:39Z Matching several values in Set analysis https://community.qlik.com/t5/QlikView/Matching-several-values-in-Set-analysis/m-p/315738#M497074 <HTML><HEAD></HEAD><BODY><P>This should work, no matter if you select one or many:</P><P>= Sum ({$&lt;[Module Compulsory Prog]=P([Programme Code])&gt;}[Student Count])</P></BODY></HTML> Wed, 05 Oct 2011 18:51:30 GMT https://community.qlik.com/t5/QlikView/Matching-several-values-in-Set-analysis/m-p/315738#M497074 Anonymous 2011-10-05T18:51:30Z