Display Dimension based on Max(Sales) - Qlik Community

rxp03570 · ‎2018-11-27

Hi All,

I need to display dimension based on Max(Sales), want to display product which has Max(Sales) in a straight table.

Any help on how to achieve this.

Thanks,

Anil_Babu_Samineni · ‎2018-11-27

Perhaps this?

If Expression - FirstSortedValue(Sales, -Aggr(Sum(Sales), Dimension))

Or

If Dimension - If(Sales=Max(TOTAL Sales), Dimension)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

rxp03570 · ‎2018-11-28

No luck with this

Anonymous · ‎2018-11-28

Hi, please try this set expression : =Max(Aggr(Sum(Sales),Month))

Anonymous · ‎2018-11-28

and Dimension must be Product