topic Please Help for sum by specific dimension / AGGR function in QlikView https://community.qlik.com/t5/QlikView/Please-Help-for-sum-by-specific-dimension-AGGR-function/m-p/436210#M488308 <HTML><HEAD></HEAD><BODY><P>Hello i try in a simple table with 2 dimensions (Tiers comptable (Customer) ans Numpiece (NumOrder) and the expression below : </P><P></P><P>=If(Today()-[D_ENTET.Date d'échéance de la pièce]&gt;=0,sum({$&lt;[D_ENTET.Module d'origine] = {"2 - Comptabilité"},[D_COMPTECPTA.Compte cumul 2] = {41},NumPiece =&gt;} [F_COMPTABLE2.Solde (D-C) en devise société]),0)</P><P></P><P>In a simple tab, i can display the total automaticaly with option graphic object.</P><P></P><P>i would like to make a sum of my expression by only dimension Tiers comptable (Customer) but it doesn't work !!!</P><P></P><P>I try with AGGR function but the result it's not OK. I want to display the sum of lines whith are ok in my test if today...</P><P></P><P>I would like to obtain the result 352274,4 for the customer 0002076145 but with a sum or aggr function in my expression.</P><P></P><P>Please see the attachement for concrete example.</P></BODY></HTML> Sat, 19 Jan 2013 08:49:35 GMT 2013-01-19T08:49:35Z Please Help for sum by specific dimension / AGGR function https://community.qlik.com/t5/QlikView/Please-Help-for-sum-by-specific-dimension-AGGR-function/m-p/436210#M488308 <HTML><HEAD></HEAD><BODY><P>Hello i try in a simple table with 2 dimensions (Tiers comptable (Customer) ans Numpiece (NumOrder) and the expression below : </P><P></P><P>=If(Today()-[D_ENTET.Date d'échéance de la pièce]&gt;=0,sum({$&lt;[D_ENTET.Module d'origine] = {"2 - Comptabilité"},[D_COMPTECPTA.Compte cumul 2] = {41},NumPiece =&gt;} [F_COMPTABLE2.Solde (D-C) en devise société]),0)</P><P></P><P>In a simple tab, i can display the total automaticaly with option graphic object.</P><P></P><P>i would like to make a sum of my expression by only dimension Tiers comptable (Customer) but it doesn't work !!!</P><P></P><P>I try with AGGR function but the result it's not OK. I want to display the sum of lines whith are ok in my test if today...</P><P></P><P>I would like to obtain the result 352274,4 for the customer 0002076145 but with a sum or aggr function in my expression.</P><P></P><P>Please see the attachement for concrete example.</P></BODY></HTML> Sat, 19 Jan 2013 08:49:35 GMT https://community.qlik.com/t5/QlikView/Please-Help-for-sum-by-specific-dimension-AGGR-function/m-p/436210#M488308 2013-01-19T08:49:35Z