https://community.qlik.com/t5/Visualization-and-Usability/Count-OR/m-p/1708012#M165251 <P>Hello</P><P>I want to count each patient once if they have at least one of the items = 1&nbsp;</P><P>This is what I am trying to use but it is counting all patients&nbsp;</P><P>=count(distinct if(PreferredLanguageFlag='1' or<BR />CountryofBirthFlag='1' or<BR />EthnicityFlag='1' or<BR />InterpreterFlag='1',<BR />[Patient]) )</P><P>Does anybody know where I am going wrong?&nbsp;</P><P>Thank you</P><P>&nbsp;</P> Sat, 16 Nov 2024 18:32:27 GMT Taylorcc 2024-11-16T18:32:27Z https://community.qlik.com/t5/Visualization-and-Usability/Count-OR/m-p/1708012#M165251 <P>Hello</P><P>I want to count each patient once if they have at least one of the items = 1&nbsp;</P><P>This is what I am trying to use but it is counting all patients&nbsp;</P><P>=count(distinct if(PreferredLanguageFlag='1' or<BR />CountryofBirthFlag='1' or<BR />EthnicityFlag='1' or<BR />InterpreterFlag='1',<BR />[Patient]) )</P><P>Does anybody know where I am going wrong?&nbsp;</P><P>Thank you</P><P>&nbsp;</P> Sat, 16 Nov 2024 18:32:27 GMT https://community.qlik.com/t5/Visualization-and-Usability/Count-OR/m-p/1708012#M165251 Taylorcc 2024-11-16T18:32:27Z https://community.qlik.com/t5/Visualization-and-Usability/Count-OR/m-p/1708035#M165254 <P>Using Set Analysis:<BR /><SPAN>=count({&lt;PreferredLanguageFlag={'1'}, CountryofBirthFlag={'1'},&nbsp;</SPAN><SPAN>EthnicityFlag={'1'}, InterpreterFlag={'1'}&gt;}distinct&nbsp;</SPAN><SPAN>[Patient])&nbsp;</SPAN></P> Thu, 04 Jun 2020 04:34:04 GMT https://community.qlik.com/t5/Visualization-and-Usability/Count-OR/m-p/1708035#M165254 Lisa_P 2020-06-04T04:34:04Z https://community.qlik.com/t5/Visualization-and-Usability/Count-OR/m-p/1708043#M165256 <P>hi&nbsp;</P><P>your expression looks ok&nbsp;</P><P>why do you think it doesn't work?</P> Thu, 04 Jun 2020 05:23:42 GMT https://community.qlik.com/t5/Visualization-and-Usability/Count-OR/m-p/1708043#M165256 lironbaram 2020-06-04T05:23:42Z