Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
thomas_muserepw
New Contributor

Minimum of a Summed Column

stalwar1

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

Tags (1)
2 Replies
Highlighted
jwjackso
Valued Contributor

Re: Minimum of a Summed Column

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))

Highlighted
thomas_muserepw
New Contributor

Re: Minimum of a Summed Column

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