topic Re: Aggregation in QlikView https://community.qlik.com/t5/QlikView/Aggregation/m-p/406871#M488368 <HTML><HEAD></HEAD><BODY><P>Thank you very much! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 09 Jan 2013 12:35:35 GMT johnso2080 2013-01-09T12:35:35Z Aggregation https://community.qlik.com/t5/QlikView/Aggregation/m-p/406869#M488365 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a table like the below....</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="160" style="border: 1px solid rgb(0, 0, 0); width: 421px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle">Model</TH><TH align="center" style="background-color: #6690bc;" valign="middle">Item</TH><TH align="center" style="background-color: #6690bc;" valign="middle">Colour</TH><TH align="center" style="background-color: #6690bc;" valign="middle">Views</TH></TR><TR><TD>A</TD><TD>1</TD><TD>BLUE</TD><TD>4000</TD></TR><TR><TD>A</TD><TD>1</TD><TD>GREEN</TD><TD>4000</TD></TR><TR><TD>A</TD><TD>1</TD><TD>BLACK</TD><TD>4000</TD></TR><TR><TD>A</TD><TD>2</TD><TD>BLUE</TD><TD>1200</TD></TR><TR><TD>A</TD><TD>2</TD><TD>GREEN</TD><TD>1200</TD></TR><TR><TD>B</TD><TD>3</TD><TD>RED</TD><TD>2600</TD></TR></TBODY></TABLE><P></P><P>What I want to do is add up the 'Views' for each model, but removing the duplication by colour.</P><P>So that the total views for item '1' = 4000, and item '2' = 1200 so the total for model 'A' would be 5200.</P><P>I've tried a couple of different Aggr() formula variations but I'm having some trouble! Any advice would be much appreciated!</P><P></P><P>Thanks</P><P></P><P>Darren</P></BODY></HTML> Wed, 09 Jan 2013 10:20:13 GMT https://community.qlik.com/t5/QlikView/Aggregation/m-p/406869#M488365 johnso2080 2013-01-09T10:20:13Z Re: Aggregation https://community.qlik.com/t5/QlikView/Aggregation/m-p/406870#M488367 <HTML><HEAD></HEAD><BODY><P>Per Model and Item:</P><P>AGGR(SUM(DISTINCT Views), Model, Item)</P><P></P><P>Per model:</P><P>AGGR(SUM(AGGR(SUM(DISTINCT Views), Model, Item)), Model)</P></BODY></HTML> Wed, 09 Jan 2013 10:28:41 GMT https://community.qlik.com/t5/QlikView/Aggregation/m-p/406870#M488367 2013-01-09T10:28:41Z Re: Aggregation https://community.qlik.com/t5/QlikView/Aggregation/m-p/406871#M488368 <HTML><HEAD></HEAD><BODY><P>Thank you very much! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 09 Jan 2013 12:35:35 GMT https://community.qlik.com/t5/QlikView/Aggregation/m-p/406871#M488368 johnso2080 2013-01-09T12:35:35Z