topic Re: SumIf in QlikView https://community.qlik.com/t5/QlikView/SumIf/m-p/783590#M1031406 <HTML><HEAD></HEAD><BODY><P>like this?</P><P></P><P><IMG alt="1.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/76519_1.png" style="height: auto; width: auto;" /></P></BODY></HTML> Wed, 28 Jan 2015 21:02:35 GMT maxgro 2015-01-28T21:02:35Z SumIf https://community.qlik.com/t5/QlikView/SumIf/m-p/783585#M1031401 <HTML><HEAD></HEAD><BODY><P>Olá,</P><P></P><P>Gostaria de saber se existe uma função equivalente a SumIf do Excel, ou saber se tem alguma forma de fazer uma função assim.</P><P></P><P>Obrigada </P></BODY></HTML> Wed, 28 Jan 2015 17:30:34 GMT https://community.qlik.com/t5/QlikView/SumIf/m-p/783585#M1031401 2015-01-28T17:30:34Z Re: SumIf https://community.qlik.com/t5/QlikView/SumIf/m-p/783586#M1031402 <HTML><HEAD></HEAD><BODY><P>=IF(Condition = ' ',SUM(Field)) AS Field</P></BODY></HTML> Wed, 28 Jan 2015 17:31:54 GMT https://community.qlik.com/t5/QlikView/SumIf/m-p/783586#M1031402 NickHoff 2015-01-28T17:31:54Z Re: SumIf https://community.qlik.com/t5/QlikView/SumIf/m-p/783587#M1031403 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>great thread</P><P></P><P><A href="https://community.qlik.com/thread/74494">When is it best to use sum(if()) over Set Analysis in an expression?</A></P><P></P><P>HTH</P><P></P><P>André Gomes</P></BODY></HTML> Wed, 28 Jan 2015 17:36:57 GMT https://community.qlik.com/t5/QlikView/SumIf/m-p/783587#M1031403 agomes1971 2015-01-28T17:36:57Z Re: SumIf https://community.qlik.com/t5/QlikView/SumIf/m-p/783588#M1031404 <HTML><HEAD></HEAD><BODY><P>Não funcionou. </P><P></P><P>Eu estou querendo contar erros, por exemplo:</P><P></P><P></P><P>Linha&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Erro1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Erro2</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; App&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HW</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">HW&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">App&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></SPAN></P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">App&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">HW</SPAN>&nbsp;&nbsp; </SPAN></P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">HW&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">App&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></SPAN></P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">App&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">App&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P>6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">HW&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">HW</SPAN></SPAN></P><P></P><P></P><P>Queria um jeito de que ele contasse o Erro 1 e o 2 e mostrasse quantos erros de APP e de HW que tenho.</P><P></P><P>Att;</P></BODY></HTML> Wed, 28 Jan 2015 17:41:06 GMT https://community.qlik.com/t5/QlikView/SumIf/m-p/783588#M1031404 2015-01-28T17:41:06Z Re: SumIf https://community.qlik.com/t5/QlikView/SumIf/m-p/783589#M1031405 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=Sum(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">If(Condition = something, Field)</SPAN>) as SumIfField<BR /></SPAN></P></BODY></HTML> Wed, 28 Jan 2015 20:56:42 GMT https://community.qlik.com/t5/QlikView/SumIf/m-p/783589#M1031405 MarcoWedel 2015-01-28T20:56:42Z Re: SumIf https://community.qlik.com/t5/QlikView/SumIf/m-p/783590#M1031406 <HTML><HEAD></HEAD><BODY><P>like this?</P><P></P><P><IMG alt="1.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/76519_1.png" style="height: auto; width: auto;" /></P></BODY></HTML> Wed, 28 Jan 2015 21:02:35 GMT https://community.qlik.com/t5/QlikView/SumIf/m-p/783590#M1031406 maxgro 2015-01-28T21:02:35Z Re: SumIf https://community.qlik.com/t5/QlikView/SumIf/m-p/783591#M1031407 <HTML><HEAD></HEAD><BODY><P>Não funcionou pessoal,</P><P></P><P>Help me, PLEASE <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Thu, 29 Jan 2015 13:02:25 GMT https://community.qlik.com/t5/QlikView/SumIf/m-p/783591#M1031407 2015-01-29T13:02:25Z Re: SumIf https://community.qlik.com/t5/QlikView/SumIf/m-p/783592#M1031408 <HTML><HEAD></HEAD><BODY><P>Resolvi, obrigada.</P></BODY></HTML> Fri, 27 Feb 2015 13:17:32 GMT https://community.qlik.com/t5/QlikView/SumIf/m-p/783592#M1031408 2015-02-27T13:17:32Z