Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ali_hijazi
Honored Contributor

rank salesmen

Hello

I have a chart in which I'm displaying names of salesmen and next to each one I'm displaying the count of invoices related to each salesman

what I want now is to display the rank of each salesman based on the number of invoices

I have the dimension set to the salesman code and in the third column the expression is rank(count(invoice))

what I'm getting in the rank column is numbers 1,2,4,... but these numbers are being repeated for other salesmen even if the number of invoices is different

Please help

1 Solution

Accepted Solutions
ali_hijazi
Honored Contributor

rank salesmen

ah No

I want to apply the ranking on the second dimension not all the dimensions

I used AGGR(rank(count(cardCode)); cardCode is the id of the invoice in my database

and I got what I want!!!

Please select this as correct answer!!!

5 Replies
Not applicable

Re: rank salesmen

I have taken some sample data and tried what u want.Try this else upload some sample data.

ali_hijazi
Honored Contributor

rank salesmen

you example is helpful but I have 2 dimensions the first one is the group of salesmen and the second one is the salesmen code

I want to rank an expression based on the second dimension

pat_agen
Valued Contributor

rank salesmen

hi,

then add the TOTAL qualifier to the rank() expression.

see picture

Total.png

Not applicable

Re: rank salesmen

Pat.agen is right.

'Total'  will work for u...

ali_hijazi
Honored Contributor

rank salesmen

ah No

I want to apply the ranking on the second dimension not all the dimensions

I used AGGR(rank(count(cardCode)); cardCode is the id of the invoice in my database

and I got what I want!!!

Please select this as correct answer!!!