topic Re: Aggr an Aggr function? in QlikView https://community.qlik.com/t5/QlikView/Aggr-an-Aggr-function/m-p/640231#M1088899 <HTML><HEAD></HEAD><BODY><P>can you please post some test data?</P><P>thanks</P><P>regards</P><P>Marco</P></BODY></HTML> Tue, 20 May 2014 20:11:12 GMT MarcoWedel 2014-05-20T20:11:12Z Aggr an Aggr function? https://community.qlik.com/t5/QlikView/Aggr-an-Aggr-function/m-p/640230#M1088898 <HTML><HEAD></HEAD><BODY><P>I have the following Aggr function that operates as it should</P><P></P><P>fabs( StdMdl *&nbsp; Max (TOTAL Aggr (Sum (&nbsp; {&lt; GapAnalysisFlag = {1} &gt;}&nbsp; [Net Sales]) / StdMdl&nbsp; , [Forecast Product Line DESC]))) - Sum( {&lt; GapAnalysisFlag = {1} &gt;}&nbsp; [Net Sales])</P><P></P><P>So, when a customer is selected the chart displays:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProdLineA&nbsp;&nbsp; ProdLineB&nbsp;&nbsp; ProdLineC&nbsp;&nbsp;&nbsp; ProdLineD </P><P>CustomerA&nbsp;&nbsp; $0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $2,350&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $5,103&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $4,987 </P><P></P><P>However, when the selection is more broad the data changes. For example when a Group that consists of Customers A &amp; B (and others) the data changes to the following&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProdLineA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProdLineB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProdLineC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProdLineD </P><P>CustomerA&nbsp;&nbsp; $101,000,700&nbsp;&nbsp; $28,484,709&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $5,103,864&nbsp;&nbsp;&nbsp;&nbsp; $4,987,849 </P><P>CustomerB&nbsp;&nbsp; $101,000,600&nbsp;&nbsp; $26,156,123&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $26,100,800&nbsp;&nbsp; $48,456,123</P><P>CustomerC...</P><P></P><P>What I would like to display is:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProdLineA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProdLineB&nbsp;&nbsp;&nbsp;&nbsp; ProdLineC&nbsp;&nbsp; ProdLineD </P><P>CustomerA&nbsp;&nbsp;&nbsp; $0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $2,350&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $5,103&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $4,987 </P><P>CustomerB&nbsp;&nbsp;&nbsp; $6,156&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $3,120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $6,800 </P><P>CustomerC ...</P></BODY></HTML> Tue, 20 May 2014 17:58:27 GMT https://community.qlik.com/t5/QlikView/Aggr-an-Aggr-function/m-p/640230#M1088898 hobanwashburne 2014-05-20T17:58:27Z Re: Aggr an Aggr function? https://community.qlik.com/t5/QlikView/Aggr-an-Aggr-function/m-p/640231#M1088899 <HTML><HEAD></HEAD><BODY><P>can you please post some test data?</P><P>thanks</P><P>regards</P><P>Marco</P></BODY></HTML> Tue, 20 May 2014 20:11:12 GMT https://community.qlik.com/t5/QlikView/Aggr-an-Aggr-function/m-p/640231#M1088899 MarcoWedel 2014-05-20T20:11:12Z Re: Re: Aggr an Aggr function? https://community.qlik.com/t5/QlikView/Aggr-an-Aggr-function/m-p/640232#M1088900 <HTML><HEAD></HEAD><BODY><P>see attached</P></BODY></HTML> Wed, 21 May 2014 14:57:44 GMT https://community.qlik.com/t5/QlikView/Aggr-an-Aggr-function/m-p/640232#M1088900 hobanwashburne 2014-05-21T14:57:44Z