topic Re: Conditional Sum in QlikView https://community.qlik.com/t5/QlikView/Conditional-Sum/m-p/743924#M536719 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px; line-height: 1.5em;">=Num(SUM(Aggr(IF(SUM(Venta)&gt;SUM({&lt;Tipo = {'Medios'}&gt;}Inversion),SUM(Venta),Marca)),</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">'$#,##0')</SPAN></P></BODY></HTML> Fri, 28 Nov 2014 22:28:13 GMT MK_QSL 2014-11-28T22:28:13Z Conditional Sum https://community.qlik.com/t5/QlikView/Conditional-Sum/m-p/743923#M536718 <HTML><HEAD></HEAD><BODY><P>Hello Good evening,</P><P></P><P>I would like to add the value of a field when the condition is valid, I'm using the following formula:</P><P></P><P>=IF(Sum(Aggr(Sum(Venta),Marca))&gt;Sum(Aggr(Sum({&lt;Tipo={[Medios]}&gt;} Inversion),Marca)),Num(Sum(Aggr(Sum(Venta),Marca)),'$#,##0'))</P><P></P><P>But that expression gives me the total value of the sell and I would like to see onlye the value of the sell in those cases where the investment in media is grater. And that why I'm using the AGGT at a brand level</P><P></P><P>Does somebody can help me? Im using the formula in a text object</P><P></P><P>Thank you</P></BODY></HTML> Fri, 28 Nov 2014 21:56:53 GMT https://community.qlik.com/t5/QlikView/Conditional-Sum/m-p/743923#M536718 Anonymous 2014-11-28T21:56:53Z Re: Conditional Sum https://community.qlik.com/t5/QlikView/Conditional-Sum/m-p/743924#M536719 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px; line-height: 1.5em;">=Num(SUM(Aggr(IF(SUM(Venta)&gt;SUM({&lt;Tipo = {'Medios'}&gt;}Inversion),SUM(Venta),Marca)),</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333330154419px;">'$#,##0')</SPAN></P></BODY></HTML> Fri, 28 Nov 2014 22:28:13 GMT https://community.qlik.com/t5/QlikView/Conditional-Sum/m-p/743924#M536719 MK_QSL 2014-11-28T22:28:13Z Re: Conditional Sum https://community.qlik.com/t5/QlikView/Conditional-Sum/m-p/743925#M536720 <HTML><HEAD></HEAD><BODY><P>Thank you!!! It Works</P></BODY></HTML> Fri, 28 Nov 2014 23:08:24 GMT https://community.qlik.com/t5/QlikView/Conditional-Sum/m-p/743925#M536720 Anonymous 2014-11-28T23:08:24Z