https://community.qlik.com/t5/Visualization-and-Usability/Set-Analysis-using-E/m-p/1893238#M200049 <P>I have an expression that looks like this:</P> <P><BR />=COUNT(TOTAL {&lt; patient_region=E({&lt;patient_region={'$(vCurrentRegion)'}&gt;}), patient_province , admission_category &gt;} patient_id)</P> <P>This should calculate the total number of cases excluding the cases in the current region selected. For some reason it is still counting the cases in the current region. Is there anything wrong with my set analysis?</P> Tue, 15 Feb 2022 15:41:41 GMT nira 2022-02-15T15:41:41Z https://community.qlik.com/t5/Visualization-and-Usability/Set-Analysis-using-E/m-p/1893238#M200049 <P>I have an expression that looks like this:</P> <P><BR />=COUNT(TOTAL {&lt; patient_region=E({&lt;patient_region={'$(vCurrentRegion)'}&gt;}), patient_province , admission_category &gt;} patient_id)</P> <P>This should calculate the total number of cases excluding the cases in the current region selected. For some reason it is still counting the cases in the current region. Is there anything wrong with my set analysis?</P> Tue, 15 Feb 2022 15:41:41 GMT https://community.qlik.com/t5/Visualization-and-Usability/Set-Analysis-using-E/m-p/1893238#M200049 nira 2022-02-15T15:41:41Z https://community.qlik.com/t5/Visualization-and-Usability/Set-Analysis-using-E/m-p/1893247#M200050 <P>You can do without E.&nbsp;</P> <P><SPAN>=COUNT(TOTAL {&lt; patient_region<STRONG>-={'$(vCurrentRegion)'},</STRONG> patient_province , admission_category &gt;} patient_id)</SPAN></P> Tue, 15 Feb 2022 15:51:40 GMT https://community.qlik.com/t5/Visualization-and-Usability/Set-Analysis-using-E/m-p/1893247#M200050 Almen 2022-02-15T15:51:40Z