topic Re: Rank Function in QlikView

Rank Function

anjali0108 — Wed, 28 Jun 2017 05:09:59 GMT

Hi,

I am using rank function on one column and getting the below results:

The formula used for Rank is :

=Rank(count({$<[Common Ticket Type]={'INCIDENT'}>} TicketID),4)

But if you will see below the rank in column 1 should be '3' for value '82' in column 2 but it is coming 12.

Please let me know if I am doing something wrong.

Also using these ranks I am storing top 10 resolver groups in variables.

My requirement is that I want to show the top 10 resolver groups based on the calculation done in column 2 above and show it like A,B,C etc below in descending order:

Re: Rank Function

prma7799 — Wed, 28 Jun 2017 05:14:34 GMT

In my application it is work fine.

Try like this

=Rank(count({$<[Common Ticket Type]={'INCIDENT'}>} TicketID))

Or Please share some sample app

Re: Rank Function

antoniotiman — Wed, 28 Jun 2017 05:39:06 GMT

Hi,

in Count You are using DISTINCT, not in Rank.

Regards,

Antonio

Re: Rank Function

balar025 — Wed, 28 Jun 2017 05:42:36 GMT

Hi,

both the formula are different. One is distinct count and other is all count with rank.

Re: Rank Function

anjali0108 — Wed, 28 Jun 2017 05:43:14 GMT

Hey,

Thanks dear .

Re: Rank Function

anjali0108 — Wed, 28 Jun 2017 06:06:37 GMT

Hi Antonio,

Thanks ,That was a blunder that I did.

Also,could you please tell me if I have two same ranks like 7-8 for 2 different resolver groups,how can i take both of them as I have to show 10 top count even if two groups have same count.

Currently I am using mode 4 in rank

Re: Rank Function

antoniotiman — Wed, 28 Jun 2017 06:16:05 GMT

Rank(.......,0,1)