topic Re: How to filter over rows with If? in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-over-rows-with-If/m-p/425605#M1155041 <HTML><HEAD></HEAD><BODY><P>Hi, perfect. Thanks! Zach.</P></BODY></HTML> Sun, 10 Mar 2013 10:36:52 GMT 2013-03-10T10:36:52Z How to filter over rows with If? https://community.qlik.com/t5/QlikView/How-to-filter-over-rows-with-If/m-p/425603#M1155039 <HTML><HEAD></HEAD><BODY><P>Hi, why do i miss the two amounts of Orderno 2 in the second table?</P><P><IMG __jive_id="34685" class="jive-image-thumbnail jive-image" onclick="" alt="Screen.png" src="https://community.qlik.com/legacyfs/online/34685_Screen.png" width="450" /></P></BODY></HTML> Sun, 10 Mar 2013 08:39:28 GMT https://community.qlik.com/t5/QlikView/How-to-filter-over-rows-with-If/m-p/425603#M1155039 2013-03-10T08:39:28Z Re: How to filter over rows with If? https://community.qlik.com/t5/QlikView/How-to-filter-over-rows-with-If/m-p/425604#M1155040 <HTML><HEAD></HEAD><BODY><P>The problem is that your if statement doesn't aggregate. So for any OrderNo with more than one record it can't determine which sum(Amount) it should use. Sum(200) or sum(120).</P><P></P><P>What you probably want is the other way around: <EM>sum(if(PartGroup='PartB' and left(PartNo,1)=3,Amount)). </EM></P><P></P><P>You can rewrite that to a set analysis expression:</P><P><EM>sum({&lt;PartGroup={'PartB'},PartNo={"=left(PartNo,1)=3"}&gt;} Amount)</EM></P></BODY></HTML> Sun, 10 Mar 2013 10:06:15 GMT https://community.qlik.com/t5/QlikView/How-to-filter-over-rows-with-If/m-p/425604#M1155040 Gysbert_Wassenaar 2013-03-10T10:06:15Z Re: How to filter over rows with If? https://community.qlik.com/t5/QlikView/How-to-filter-over-rows-with-If/m-p/425605#M1155041 <HTML><HEAD></HEAD><BODY><P>Hi, perfect. Thanks! Zach.</P></BODY></HTML> Sun, 10 Mar 2013 10:36:52 GMT https://community.qlik.com/t5/QlikView/How-to-filter-over-rows-with-If/m-p/425605#M1155041 2013-03-10T10:36:52Z