topic Re: Wighted Ranking in QlikView

Wighted Ranking

QlikUser555 — Mon, 26 Jan 2026 18:19:17 GMT

Hello,

I would like to calculate the Rank of a individual country by different wights. The wights I want to adjust by a slider. The Slider is already build an writes to a new variable for every wight e.g.: vWight1 = 30, vWight2 = 40 and vWight3=30 (all Wights together are always 100). For every Country there are 3 different Values to build the Ranking.

The Data looks like this:

Country | Wight ID | Value

Germany | 1 | 34

Germany | 2 | 45

Germany | 3 | 12

UK | 1 | 42

UK | 2 | 76

UK | 3 | 98

USA | 1 | 67

USA | 2 | 65

USA | 3 | 13

The calculation should now for Germany be:

30*34+40*45+30*12 = Index

And than I want to write to every country a new col with the Ranking 1 to inf ...

I have no Idea how to deal with this.

Greetings,

Tobias

Re: Wighted Ranking

Frank_Hartmann — Mon, 02 Sep 2019 10:45:18 GMT

Maybe like this:

script:

Map: Mapping Load *Inline [ Wight ID, Wight 1, 30 2, 40 3, 30 ]; Test2: Load *, ApplyMap('Map',[Wight ID],Null())*Value as Index; Load * Inline [ Country | Wight ID | Value Germany | 1 | 34 Germany | 2 | 45 Germany | 3 | 12 UK | 1 | 42 UK | 2 | 76 UK | 3 | 98 USA | 1 | 67 USA | 2 | 65 USA | 3 | 13 ] (delimiter is |);

straight Table:

dimension:

Country

Expressions:

sum(Index)

rank(sum(Index))

hope this helps

Re: Wighted Ranking

Brett_Bleess — Tue, 10 Sep 2019 16:48:22 GMT

Tobias, did Frank's post and sample app work for you? If so, please be sure to use the Accept as Solution button on his post to give him credit for the help as well as let others know things worked. If you are still having trouble, please provide an update.

Regards,
Brett