Qlik Community

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.

    

RegionSupplier NameAverage weights
(Weight*KPI's)
Rank region wise
APACxyz17.751
APACxyz27.52
APACxyz35.73
Europeabc44.41
Americasghi56.31
Americasghi66.052

   

1 Solution

Accepted Solutions
laddu_927
Valued Contributor

Re: How to use rank function

Sorry, I answered for Qlikview.

Load the data.

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.

laddu_927
Valued Contributor

Re: How to use rank function

Like this??

Not applicable

Re: How to use rank function

Shiva thanks for replying ..

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 ?

load * inline [

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]:

load * inline [

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]:

Load

    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.

laddu_927
Valued Contributor

Re: How to use rank function

Sorry, I answered for Qlikview.

Load the data.

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

Community Browser