Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Honored Contributor II

Re: How can i veiw Max sale of person

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

8 Replies
prma7799
Honored Contributor III

Re: How can i veiw Max sale of person

Can you please provide some data?

Re: How can i veiw Max sale of person

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
Contributor II

Re: How can i veiw Max sale of person

Could you please be a little more specific?

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

Best regards.

buzzy996
Honored Contributor II

Re: How can i veiw Max sale of person

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

gautik92
Valued Contributor III

Re: How can i veiw Max sale of person

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

sureshqv
Esteemed Contributor III

Re: How can i veiw Max sale of person

hi

sum(Dimension)

Max(Dim)

Min(Dim)

count(Dim)

hope this helps you

Thank you

Suresh

hariprasadqv
Contributor III

Re: How can i veiw Max sale of person

Hi,

Dimension: Name

Expression: max(sum(sales))

Not applicable

Re: How can i veiw Max sale of person

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

Community Browser