Qlik Community

Qlik Healthcare User Group

This group is for healthcare organizations, partners, and Qlik Healthcare staff to collaborate and share insights.

Highlighted
richardouellett
New Contributor III

Rank() based on frequency & Formatting?

Hi

I am trying to format rank in the attached example, as well as have the rank reflect frequency and that it shows the actual rank 1 - 4 instead of the stating row number, e.g., 1 would remain 1 and 39 would reflect rank 2.  Seem like CAOR should have been ranked # since it had a frequency of 8?  Can you assist?

 

Tags (1)
1 Solution

Accepted Solutions

Re: Rank() based on frequency & Formatting?

Sorry about that, try this:

Aggr(NODISTINCT Num(Rank(Count(Process), 4)), Process)

Capture.PNG

4 Replies

Re: Rank() based on frequency & Formatting?

May be this:

Aggr(NODISTINCT Rank(Process), Process)

Capture.PNG

richardouellett
New Contributor III

Re: Rank() based on frequency & Formatting?

Sunny that fixes the numbering format but the ranking based on frequency is not adding up?

Re: Rank() based on frequency & Formatting?

Sorry about that, try this:

Aggr(NODISTINCT Num(Rank(Count(Process), 4)), Process)

Capture.PNG

richardouellett
New Contributor III

Re: Rank() based on frequency & Formatting?

Sunny thanks so much, that did the trick!