topic Re: Expression for Peer Group Sales in QlikView https://community.qlik.com/t5/QlikView/Expression-for-Peer-Group-Sales/m-p/1075969#M358939 <HTML><HEAD></HEAD><BODY><P>Sum(Total Sales) - sum(Sales)</P></BODY></HTML> Tue, 12 Jan 2016 20:33:29 GMT maxgro 2016-01-12T20:33:29Z Expression for Peer Group Sales https://community.qlik.com/t5/QlikView/Expression-for-Peer-Group-Sales/m-p/1075968#M358938 <HTML><HEAD></HEAD><BODY><P>I need to know what the expression for Peer Sales would be. Basically gettting sales for all customers except the customer line you are on.&nbsp; Customer A has sales of 10, peer sales of 50 (B+C),&nbsp; Customer B has sales of 20, with peer sales of 40 (A+C), etc.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="219"><TBODY><TR><TD height="20" width="89">Customer</TD><TD width="66">Sales</TD><TD width="64">Peer Sales</TD></TR><TR><TD height="20">A</TD><TD align="right">10</TD><TD align="right">50</TD></TR><TR><TD height="20">B</TD><TD align="right">20</TD><TD align="right">40</TD></TR><TR><TD height="20">C</TD><TD align="right">30</TD><TD align="right">30</TD></TR></TBODY></TABLE><P></P><P>Thanks in advance,</P><P></P><P>Zag</P></BODY></HTML> Tue, 12 Jan 2016 20:26:01 GMT https://community.qlik.com/t5/QlikView/Expression-for-Peer-Group-Sales/m-p/1075968#M358938 zagzebski 2016-01-12T20:26:01Z Re: Expression for Peer Group Sales https://community.qlik.com/t5/QlikView/Expression-for-Peer-Group-Sales/m-p/1075969#M358939 <HTML><HEAD></HEAD><BODY><P>Sum(Total Sales) - sum(Sales)</P></BODY></HTML> Tue, 12 Jan 2016 20:33:29 GMT https://community.qlik.com/t5/QlikView/Expression-for-Peer-Group-Sales/m-p/1075969#M358939 maxgro 2016-01-12T20:33:29Z Re: Expression for Peer Group Sales https://community.qlik.com/t5/QlikView/Expression-for-Peer-Group-Sales/m-p/1075970#M358940 <HTML><HEAD></HEAD><BODY><P>May be this for Peer Sales</P><P></P><P><STRONG>=Sum(TOTAL Sales) - Sum(Sales)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/111412_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Tue, 12 Jan 2016 20:34:20 GMT https://community.qlik.com/t5/QlikView/Expression-for-Peer-Group-Sales/m-p/1075970#M358940 sunny_talwar 2016-01-12T20:34:20Z