topic Aggr small amounts in QlikView https://community.qlik.com/t5/QlikView/Aggr-small-amounts/m-p/422522#M560904 <HTML><HEAD></HEAD><BODY><P>I want to aggragate products that have had sales less than a certain amount into one bucket in a chart.</P><P></P><P>Ex.</P><P></P><P>Sales of Product A - 50</P><P>Sales of Product B - 60</P><P>Sales of Product C - 70</P><P>Sales of Product D - 80</P><P>Sales of Product E - 1</P><P>Sales of Product F - 2</P><P></P><P>How would I write a calculated dimension that would group any product with sales under 10 into one combined product and if it is over 10 they just remain the same?</P><P></P><P>The results in the chart:</P><P></P><P>Sales of Product A - 50</P><P>Sales of Product B - 60</P><P>Sales of Product C - 70</P><P>Sales of Product D - 80</P><P>Sales of Combined Products &lt; 10 - 3</P></BODY></HTML> Thu, 04 Apr 2013 13:41:08 GMT zagzebski 2013-04-04T13:41:08Z Aggr small amounts https://community.qlik.com/t5/QlikView/Aggr-small-amounts/m-p/422522#M560904 <HTML><HEAD></HEAD><BODY><P>I want to aggragate products that have had sales less than a certain amount into one bucket in a chart.</P><P></P><P>Ex.</P><P></P><P>Sales of Product A - 50</P><P>Sales of Product B - 60</P><P>Sales of Product C - 70</P><P>Sales of Product D - 80</P><P>Sales of Product E - 1</P><P>Sales of Product F - 2</P><P></P><P>How would I write a calculated dimension that would group any product with sales under 10 into one combined product and if it is over 10 they just remain the same?</P><P></P><P>The results in the chart:</P><P></P><P>Sales of Product A - 50</P><P>Sales of Product B - 60</P><P>Sales of Product C - 70</P><P>Sales of Product D - 80</P><P>Sales of Combined Products &lt; 10 - 3</P></BODY></HTML> Thu, 04 Apr 2013 13:41:08 GMT https://community.qlik.com/t5/QlikView/Aggr-small-amounts/m-p/422522#M560904 zagzebski 2013-04-04T13:41:08Z Re: Aggr small amounts https://community.qlik.com/t5/QlikView/Aggr-small-amounts/m-p/422523#M560905 <HTML><HEAD></HEAD><BODY><P>Something like this:</P><P></P><P>calculated dimension: if(aggr(sum(Sales)),Product)&lt;10, 'Combined Product', Product)</P><P>expression: sum(Sales)</P><P></P><P>replace Sales and Product with your field names</P></BODY></HTML> Thu, 04 Apr 2013 17:52:51 GMT https://community.qlik.com/t5/QlikView/Aggr-small-amounts/m-p/422523#M560905 Gysbert_Wassenaar 2013-04-04T17:52:51Z Re: Aggr small amounts https://community.qlik.com/t5/QlikView/Aggr-small-amounts/m-p/422524#M560906 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Thu, 04 Apr 2013 20:38:26 GMT https://community.qlik.com/t5/QlikView/Aggr-small-amounts/m-p/422524#M560906 zagzebski 2013-04-04T20:38:26Z