Second max market share

[12victory]

Hi, I need to show the producers with the second largest share in each store. I'm trying to apply this expression:

max(sum({$<year={'2021'}>}[sales]) / sum(all <Customers>{$<year={'2021'}>}[sales]),2)

but Qlik doesn't allow to use MAX and SUM together.

I will be glad if you give advice on how best to write  expression for this aim

Thank you

[brunobertels · Accepted solution]

hi 

may be 

max(

aggr(sum({$<year={'2021'}>}[sales]) / sum(all <Customers>{$<year={'2021'}>}[sales]),Producer, Store)

,2

)

[12victory]

Thanks a lot, it helped