topic Sum total from sum if in QlikView https://community.qlik.com/t5/QlikView/Sum-total-from-sum-if/m-p/1157358#M377447 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>Guys how to get sum as in Excel sumif ? =)))&nbsp; The attachment.</P></BODY></HTML> Tue, 17 May 2016 08:39:45 GMT warfollowmy_ver 2016-05-17T08:39:45Z Sum total from sum if https://community.qlik.com/t5/QlikView/Sum-total-from-sum-if/m-p/1157358#M377447 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>Guys how to get sum as in Excel sumif ? =)))&nbsp; The attachment.</P></BODY></HTML> Tue, 17 May 2016 08:39:45 GMT https://community.qlik.com/t5/QlikView/Sum-total-from-sum-if/m-p/1157358#M377447 warfollowmy_ver 2016-05-17T08:39:45Z Re: Sum total from sum if https://community.qlik.com/t5/QlikView/Sum-total-from-sum-if/m-p/1157359#M377448 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>=sum(TOTAL Aggr( if(sum(Sales)&gt;=20,sum(Sales)),Shop,Catalog,Product))</P></BODY></HTML> Tue, 17 May 2016 15:28:54 GMT https://community.qlik.com/t5/QlikView/Sum-total-from-sum-if/m-p/1157359#M377448 swuehl 2016-05-17T15:28:54Z Re: Sum total from sum if https://community.qlik.com/t5/QlikView/Sum-total-from-sum-if/m-p/1157360#M377449 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please, try this expression :</P><P></P><P>=Sum(TOTAL Aggr(if(sum(Sales)&gt;=20,sum(Sales)),Product))</P><P></P><P>Hope it helps.</P><P></P><P>Regards,</P><P></P><P>Filip Duchateau</P></BODY></HTML> Tue, 17 May 2016 15:42:06 GMT https://community.qlik.com/t5/QlikView/Sum-total-from-sum-if/m-p/1157360#M377449 Anonymous 2016-05-17T15:42:06Z Re: Sum total from sum if https://community.qlik.com/t5/QlikView/Sum-total-from-sum-if/m-p/1157361#M377450 <HTML><HEAD></HEAD><BODY><P>Thank you! </P></BODY></HTML> Tue, 17 May 2016 23:12:28 GMT https://community.qlik.com/t5/QlikView/Sum-total-from-sum-if/m-p/1157361#M377450 warfollowmy_ver 2016-05-17T23:12:28Z