topic How to use OR on sum condition in App Development https://community.qlik.com/t5/App-Development/How-to-use-OR-on-sum-condition/m-p/15324#M1062 <HTML><HEAD></HEAD><BODY><P>Hey guys</P><P></P><P>How can i do the following?</P><P></P><P>count({&lt;Date_year={$(=Max(Data_Ano))},(Marca={'ZZ'} or Marca={'HN'})&gt;} Tipo_publicacao)</P><P></P><P>Is is possible to use the "OR" operator, or do I have to separate them?</P><P></P><P>Thanks in advance,</P><P>Miguel Cunha</P></BODY></HTML> Sat, 16 Nov 2024 08:47:37 GMT Anonymous 2024-11-16T08:47:37Z How to use OR on sum condition https://community.qlik.com/t5/App-Development/How-to-use-OR-on-sum-condition/m-p/15324#M1062 <HTML><HEAD></HEAD><BODY><P>Hey guys</P><P></P><P>How can i do the following?</P><P></P><P>count({&lt;Date_year={$(=Max(Data_Ano))},(Marca={'ZZ'} or Marca={'HN'})&gt;} Tipo_publicacao)</P><P></P><P>Is is possible to use the "OR" operator, or do I have to separate them?</P><P></P><P>Thanks in advance,</P><P>Miguel Cunha</P></BODY></HTML> Sat, 16 Nov 2024 08:47:37 GMT https://community.qlik.com/t5/App-Development/How-to-use-OR-on-sum-condition/m-p/15324#M1062 Anonymous 2024-11-16T08:47:37Z Re: How to use OR on sum condition https://community.qlik.com/t5/App-Development/How-to-use-OR-on-sum-condition/m-p/15325#M1063 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Count({&lt;Date_year={$(=Max(Data_Ano))},(Marca={'ZZ'}<SPAN style="color: #ff0000;">&gt;+&lt;</SPAN>Marca={'HN'})&gt;} Tipo_publicacao)</STRONG></SPAN></P></BODY></HTML> Mon, 29 Jan 2018 17:38:25 GMT https://community.qlik.com/t5/App-Development/How-to-use-OR-on-sum-condition/m-p/15325#M1063 sunny_talwar 2018-01-29T17:38:25Z Re: How to use OR on sum condition https://community.qlik.com/t5/App-Development/How-to-use-OR-on-sum-condition/m-p/15326#M1064 <HTML><HEAD></HEAD><BODY><P>But why not just this</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Count({&lt;Date_year={$(=Max(Data_Ano))}, Marca={'ZZ', 'HN'}&gt;} Tipo_publicacao)</STRONG></P></BODY></HTML> Mon, 29 Jan 2018 17:38:59 GMT https://community.qlik.com/t5/App-Development/How-to-use-OR-on-sum-condition/m-p/15326#M1064 sunny_talwar 2018-01-29T17:38:59Z Re: How to use OR on sum condition https://community.qlik.com/t5/App-Development/How-to-use-OR-on-sum-condition/m-p/15327#M1065 <HTML><HEAD></HEAD><BODY><P>That's exactly what I needed! Thank you very much <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 29 Jan 2018 17:44:02 GMT https://community.qlik.com/t5/App-Development/How-to-use-OR-on-sum-condition/m-p/15327#M1065 Anonymous 2018-01-29T17:44:02Z