Discussion Board for collaboration regarding Qlik GeoAnalytics.
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.
Go to Solution.
Sorry, I answered for Qlikview.
Load the data.
Insert a straight table and add
Region and Supplier name as dimensions and
Average weights as measure and
Rank(sum(Average weights(Weight*KPI's))) as rank expression. Please find the attachment
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.
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)
You can try this loading script, then create a table with fields of DATA_RANK ordered by Rank_weight.
AutoNumber(Average_weights) as Rank_weight
Resident [DATA] ORDER BY Average_weights desc ;
drop table [DATA];
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.
Thanks Shiva .It works