topic Re: Minimum of a Summed Column in App Development https://community.qlik.com/t5/App-Development/Minimum-of-a-Summed-Column/m-p/124402#M8649 <HTML><HEAD></HEAD><BODY><P>tried it not working,,, was thinking something along using total function but i cant really figure it out</P></BODY></HTML> Fri, 14 Sep 2018 08:56:25 GMT Anonymous 2018-09-14T08:56:25Z Minimum of a Summed Column https://community.qlik.com/t5/App-Development/Minimum-of-a-Summed-Column/m-p/124400#M8647 <HTML><HEAD></HEAD><BODY><H2> </H2><P></P><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌</P><P></P><P>i have my data which i want to get minimum, maximum and possibly an average as I get to understand the lowest customer and top customers in terms of sales...Each customer buys several products on different dates so we have to sum(sales) of each customer first then get the min, avg, max</P><P></P><P>I have tried this Min(Sales) for which I only get the smallest number irregardless of the total lowest per all customers.</P><P></P><P>Regards</P></BODY></HTML> Thu, 13 Sep 2018 12:52:47 GMT https://community.qlik.com/t5/App-Development/Minimum-of-a-Summed-Column/m-p/124400#M8647 Anonymous 2018-09-13T12:52:47Z Re: Minimum of a Summed Column https://community.qlik.com/t5/App-Development/Minimum-of-a-Summed-Column/m-p/124401#M8648 <HTML><HEAD></HEAD><BODY><P>The aggr function <A href="https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/aggr.htm" title="https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/aggr.htm">https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/aggr.htm</A> may be helpful</P><P></P><P>Min(Aggr(Sum(Sales),Customer))</P></BODY></HTML> Thu, 13 Sep 2018 15:25:31 GMT https://community.qlik.com/t5/App-Development/Minimum-of-a-Summed-Column/m-p/124401#M8648 jwjackso 2018-09-13T15:25:31Z Re: Minimum of a Summed Column https://community.qlik.com/t5/App-Development/Minimum-of-a-Summed-Column/m-p/124402#M8649 <HTML><HEAD></HEAD><BODY><P>tried it not working,,, was thinking something along using total function but i cant really figure it out</P></BODY></HTML> Fri, 14 Sep 2018 08:56:25 GMT https://community.qlik.com/t5/App-Development/Minimum-of-a-Summed-Column/m-p/124402#M8649 Anonymous 2018-09-14T08:56:25Z