how to get Rank

[Anonymous]

Hi Experts,

I am using Rank function but rank coming but rank coming below

I am using the below logic

  =Aggr(Rank(Count(DISTINCT([Meeting Id]))),[Client Name])

Rank
2037-2153
3512-4826
2154-2302
3512-4826
3512-4826
863-877
3512-4826
2473-2684
986-1006
710-722
391-394
1171-1206
1066-1093
2037-2153
2685-3011
2685-3011
1352-1387
2037-2153
3012-3511
2303-2472
682-694
957-985
1936-2036
839-862
752-769
2303-2472
3512-4826

[karthikoffi27se]

Hi Nagarjuna,

The count of meeting ID are unique and that's why the values are combined together.

Many Thanks

Karthik

[Thiago_Justen_]

Nagarjuna,

Try this out:

Aggr(Rank(Count(DISTINCT [Meeting Id])),[Client Name])

Cheers

[petter]

It behaves as expected and as the documentation claims that it should be.

So what is it you find puzzling or not to your requirements? Could you be specific? What kind of result do you expect?

[Anonymous]

Hi Karthik,

After i placing the below logic the rank coming not in Ascending order

=Aggr(Rank(Count(DISTINCT {<[Event Date]={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"}, [Event Type]={'Non Deal Management','Conference','Field Visit','Field Trip','Other GCA','IMG - Investor Reverse Inquiry'},[Meeting Type]={'1X1','1X1*','2X1','3X1','GRP','CCL'} >}[Meeting Id]),0,1),[Client Name])

Rank

2000

300

3

266

222

2

4

1

.

.

.

..

Like this.

How to sort the Rank

[Thiago_Justen_]

Check this out:

Rank - chart function ‒ QlikView

You may use the function like this:

Rank(YOUR_FIELD, 3)

Number 3 represents the mode parameter. This means:

Cheers

[karthikoffi27se]

use sort by expression and copy paste the formula in the sort expression tab and then sort it ascending or descending.

Many Thanks

Karthik

[Anonymous]

Hi Karthik

Tried but no change in my Rank

Rank is a Calculated Dimension.

Thanks,

Nagarjuna

[Thiago_Justen_]

Try this one:

Aggr(Rank(Count(DISTINCT {<[Event Date]={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"}, [Event Type]={'Non Deal Management','Conference','Field Visit','Field Trip','Other GCA','IMG - Investor Reverse Inquiry'},[Meeting Type]={'1X1','1X1*','2X1','3X1','GRP','CCL'} >}[Meeting Id]),3),[Client Name])

Cheers

[Anonymous]

Hi Thiago,

After Trying Below expression output like below

Aggr(Rank(Count(DISTINCT {<[Event Date]={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"}, [Event Type]={'Non Deal Management','Conference','Field Visit','Field Trip','Other GCA','IMG - Investor Reverse Inquiry'},[Meeting Type]={'1X1','1X1*','2X1','3X1','GRP','CCL'} >}[Meeting Id]),3),[Client Name]))

RAnk
31
319-324
19
2462-3054
782-804
917-950
60-61
139-141
664-686
30
589-597
363-373
54
173

Thanks,

Nagarjuna