Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
rxp03570
Creator
Creator

Display Dimension based on Max(Sales)

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,

4 Replies
Anil_Babu_Samineni

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
Creator
Creator
Author

No luck with this
Anonymous
Not applicable

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

Anonymous
Not applicable

and Dimension must be Product