Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can i veiw Max sale of person

Hi Friends,

I need to show max sale person from list of sales persons can you please help me

1 Solution

Accepted Solutions
buzzy996
Master II
Master II

set as --persons field as dimension and sum(sales) as expression and on dimension limits tabs select top as 1.

View solution in original post

8 Replies
prma7799
Master III
Master III

Can you please provide some data?

avinashelite

if you want to show in the charts, you can try with the dimension limits option in the chart properties

Or if you want to get it in a text box you can you rank() function , please elaborate more

jduarte12
Partner - Creator II
Partner - Creator II

Could you please be a little more specific?

In a first guess, I would recommend you to use Set Analysis.

Best regards.

buzzy996
Master II
Master II

set as --persons field as dimension and sum(sales) as expression and on dimension limits tabs select top as 1.

gautik92
Specialist III
Specialist III

if you want to show in charts you can use dimension limits if you want to use in text box you can use rank () function

Chanty4u
MVP
MVP

hi

sum(Dimension)

Max(Dim)

Min(Dim)

count(Dim)

hope this helps you

Thank you

Suresh

hariprasadqv
Creator III
Creator III

Hi,

Dimension: Name

Expression: max(sum(sales))

Not applicable
Author

if(aggr(Rank(max(sale)) =1,Saleperson),Salesperson)