topic max sales in QlikView

max sales

prabhas277 — Tue, 23 Jun 2015 19:27:43 GMT

Hi experts,

salesperson, sales

A,10

b,20

c,30

a,15

b,25

c,35

now i want calculate the sum of max sales using set expression?

Anonymous — Tue, 23 Jun 2015 19:35:58 GMT

Max per sales person? You don't need set here:

max(aggr(sum(sales),salesperson))

maxgro — Tue, 23 Jun 2015 19:38:07 GMT

sum of max sales by person?

=sum(aggr(max(sales),salesperson))

a and A are different

cranium144 — Thu, 25 Jun 2015 11:44:45 GMT

This worked for me. I used the following and it seems to work just fine. (working with the max qty sold per part per day, not $ sold)

max(Aggr(sum([Invoice Qty]),[Invoice Date], PN))