topic formulas with different aggregation in QlikView https://community.qlik.com/t5/QlikView/formulas-with-different-aggregation/m-p/189165#M52144 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I need to do a report to analize different data aggregation level in the same formula</P><P>Ex. - Sales detail of the customer with at least 1000 €/Year<BR /> - How many customer buy al least 2 article, how mutch do they invoice and their percentage to the total</P><P>I think that problem has the same solution</P><P>The invoice archive is the maximum detail lever<BR />The dimensions are (for simplifies things): CUSTOMER_CODE,ARTICLE_CODE,DATE</P><P>I tryed that but it didn't work<BR />sum(if(sum(TOTAL &lt;CUSTOMER_CODE&gt; VALUE)&gt;1000,VALUE))</P><P>I can solve that using script level calculate field but I lose QV dinamic filter.<BR />I can't filter for year or for month.</P><P>Thanks</P></BODY></HTML> Wed, 16 Dec 2009 17:06:36 GMT 2009-12-16T17:06:36Z formulas with different aggregation https://community.qlik.com/t5/QlikView/formulas-with-different-aggregation/m-p/189165#M52144 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I need to do a report to analize different data aggregation level in the same formula</P><P>Ex. - Sales detail of the customer with at least 1000 €/Year<BR /> - How many customer buy al least 2 article, how mutch do they invoice and their percentage to the total</P><P>I think that problem has the same solution</P><P>The invoice archive is the maximum detail lever<BR />The dimensions are (for simplifies things): CUSTOMER_CODE,ARTICLE_CODE,DATE</P><P>I tryed that but it didn't work<BR />sum(if(sum(TOTAL &lt;CUSTOMER_CODE&gt; VALUE)&gt;1000,VALUE))</P><P>I can solve that using script level calculate field but I lose QV dinamic filter.<BR />I can't filter for year or for month.</P><P>Thanks</P></BODY></HTML> Wed, 16 Dec 2009 17:06:36 GMT https://community.qlik.com/t5/QlikView/formulas-with-different-aggregation/m-p/189165#M52144 2009-12-16T17:06:36Z