Discussion board where members can get started with QlikView.
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
Go to Solution.
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!!!
I have taken some sample data and tried what u want.Try this else upload some sample data.
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
then add the TOTAL qualifier to the rank() expression.
Pat.agen is right.
'Total' will work for u...