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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

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