# Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Not applicable

## How to use rank function

Hi,

i have a table as below , I need to rank the suppliers region wise  .So based on average weight, i rank a supplier only specific to that region . So every region would have its separate ranking based on weights.

 Region Supplier Name Average weights (Weight*KPI's) Rank region wise APAC xyz1 7.75 1 APAC xyz2 7.5 2 APAC xyz3 5.7 3 Europe abc4 4.4 1 Americas ghi5 6.3 1 Americas ghi6 6.05 2

1 Solution

Accepted Solutions
Valued Contributor

## Re: How to use rank function

Insert a straight table and add

Region and Supplier name as dimensions and

use

Average weights as measure and

Rank(sum(Average weights(Weight*KPI's))) as rank expression. Please find the attachment

7 Replies
Not applicable

## Re: How to use rank function

Hi,

if I'm correct.

in the script, load datas in a table.

then load a resident table with average weight group by region.

then load another resident table with autonumber(average weight) as rank order by average weight.

regards.

Valued Contributor

Like this??

Not applicable

## Re: How to use rank function

Sorry but i have new to Qliksense..can you let me know step by step how to see the ranking as an output :

Below is what it's there in your .qvw file. How to add a additional column with region wise ranking . Is there any formula for this ?

Region,Supplier Name,Average weights(Weight*KPI's)

APAC,xyz1,7.75

APAC,xyz2,7.5

APAC,xyz3,5.7

Europe,abc4,4.4

Americas,ghi5,6.3

Americas,ghi6,6.05];

Not applicable

## Re: How to use rank function

You can try this loading script, then create a table with fields of DATA_RANK ordered by Rank_weight.

[DATA]:

Region, Supplier_name,Average_weights

APAC,xyz1,7.75

APAC,xyz2,7.5

APAC,xyz3,5.7

Europe,abc4,4.4

Americas,ghi5,6.3

Americas,ghi6,6.05];

[DATA_RANK]:

Region,

Supplier_name,

Average_weights,

AutoNumber(Average_weights) as Rank_weight

Resident [DATA] ORDER BY Average_weights desc ;

drop table [DATA];

Not applicable

## Re: How to use rank function

for ranking by region, you can use in your table a mesure with:

=aggr(rank(sum(Average_weights)), Region, Rank_weight)

in script you can use autonumber() or rowno() as Rank_weight.

regards.

Valued Contributor

## Re: How to use rank function

Insert a straight table and add

Region and Supplier name as dimensions and

use

Average weights as measure and

Rank(sum(Average weights(Weight*KPI's))) as rank expression. Please find the attachment

Not applicable

## Re: How to use rank function

Thanks Shiva .It works