Minimum of a Summed Column - Qlik Community

Anonymous · ‎2018-09-13

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

I have tried this Min(Sales) for which I only get the smallest number irregardless of the total lowest per all customers.

Regards

jwjackso · ‎2018-09-13

The aggr function https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/aggr.htm may be helpful

Min(Aggr(Sum(Sales),Customer))

Anonymous · ‎2018-09-14

tried it not working,,, was thinking something along using total function but i cant really figure it out