topic aggrgation in QlikView https://community.qlik.com/t5/QlikView/aggrgation/m-p/149755#M27881 <HTML><HEAD></HEAD><BODY><P>I want to aggregate on field without to attention to some dimention?</P><P>for example i want to sum(x1) without attention some filter affect it.</P><P>for example sum(x1, exception field1)?</P><P>field 1 is filter like mounth</P></BODY></HTML> Mon, 20 Jul 2009 16:38:12 GMT 2009-07-20T16:38:12Z aggrgation https://community.qlik.com/t5/QlikView/aggrgation/m-p/149755#M27881 <HTML><HEAD></HEAD><BODY><P>I want to aggregate on field without to attention to some dimention?</P><P>for example i want to sum(x1) without attention some filter affect it.</P><P>for example sum(x1, exception field1)?</P><P>field 1 is filter like mounth</P></BODY></HTML> Mon, 20 Jul 2009 16:38:12 GMT https://community.qlik.com/t5/QlikView/aggrgation/m-p/149755#M27881 2009-07-20T16:38:12Z aggrgation https://community.qlik.com/t5/QlikView/aggrgation/m-p/149756#M27882 <HTML><HEAD></HEAD><BODY><P>If you have version 8.5 or above, you can do it with set analysis:</P><P>sum({&lt;field1=&gt;}x1)</P><P>You can mimic it in earlier versions, but there's a lot more to it.</P></BODY></HTML> Tue, 21 Jul 2009 01:11:26 GMT https://community.qlik.com/t5/QlikView/aggrgation/m-p/149756#M27882 johnw 2009-07-21T01:11:26Z