Solved: formula max - Qlik Community

Carlaf_93 · ‎2020-07-31

Good afternoon,

i want to calculate the best seller.

I have:

sales,

seller,

products.

What's the right formula?

tresesco · ‎2020-07-31

For, product-wise calculation, try with a small correction to the above expression (by @dplr-rn ), like:

firstsortedvalue(seller,-aggr(sum(sales),product, seller))

tresesco · ‎2020-07-31

Try like:

FirstSortedValue(seller, -Aggr(Sum(sales), seller))

dplr-rn · ‎2020-07-31

need more details (what kind of visual, what are the dimensions etc.) for a proper answer but roughly you need

aggr function and firstsorted value

assuming you aresomething like firstsortedvalue(seller,-aggr(sum(sales),product)) to get best sales person per product

check this for a tutorial

tresesco · ‎2020-07-31

For, product-wise calculation, try with a small correction to the above expression (by @dplr-rn ), like:

firstsortedvalue(seller,-aggr(sum(sales),product, seller))

Carlaf_93 · ‎2020-08-03

I would like to have it in a KPI but it isn't a numeric value.

And the formula doesn't work.

formula max