topic expression help in QlikView https://community.qlik.com/t5/QlikView/expression-help/m-p/659119#M240467 <HTML><HEAD></HEAD><BODY><P>hi i have the following problem.</P><P></P><P>i wish to break out returns ( where only a return has been made) from sales + returns on the same receipt.</P><P></P><P>below is my dataset my desired result</P><P></P><P>Receipt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount</P><P>1056&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Return&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P>1056&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Return&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>1030&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Return&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P></P><P>ie. Result should show 300 and count for only Return rows should show 1.</P><P></P><P>i have attached a qvw to easier illustrate the issue.</P><P></P><P>Best</P><P>Brad</P></BODY></HTML> Mon, 22 Sep 2014 09:18:35 GMT 2014-09-22T09:18:35Z expression help https://community.qlik.com/t5/QlikView/expression-help/m-p/659119#M240467 <HTML><HEAD></HEAD><BODY><P>hi i have the following problem.</P><P></P><P>i wish to break out returns ( where only a return has been made) from sales + returns on the same receipt.</P><P></P><P>below is my dataset my desired result</P><P></P><P>Receipt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount</P><P>1056&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Return&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P>1056&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Return&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>1030&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Return&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P></P><P>ie. Result should show 300 and count for only Return rows should show 1.</P><P></P><P>i have attached a qvw to easier illustrate the issue.</P><P></P><P>Best</P><P>Brad</P></BODY></HTML> Mon, 22 Sep 2014 09:18:35 GMT https://community.qlik.com/t5/QlikView/expression-help/m-p/659119#M240467 2014-09-22T09:18:35Z