rank but in the same dimension

[bbmmouha]

i have a dimension called part i want the rank of parti in the same dimension called lib_reg

any help

thank you community

[Oleg_Troyansky]

I'm not sure I understood your request properly... If you want to create a dimension that ranks the products, you can do it using the Advanced Aggregation function AGGR, like this:

AGGR( rank(sum([NBR_VOTE])), Product)

I'm not sure what you mean when you say "in the same dimension". I suppose you could create a "Dual" value, with the Product name as a text and its rank as a number:

AGGR(

     Dual( Product,

               rank(sum([NBR_VOTE]), 4)

, Product)

Notice the second parameter "4" in the Rank() function - you need to add it, in order to ensure that each product receives a unique rank number.

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business - available to pre-order on Amazon with a 33% discount.

[bbmmouha]

thanks for your reply

what i want is ,in the exemple it ranks parti in the lib_reg dimension , rank selected "parti" in the sale region

for exemple if i select parti 1 i shoud have it s rank in region 1

[Oleg_Troyansky]

I think this blog post on my website should help your need:

Q-Tip #8 – Ranking the Unrankable | Natural Synergies

cheers,

Oleg Troyansky

[bbmmouha]

thanks a lot

but if i explain more

this the situation i want rank(sum(sales)) of the product in the area

[bbmmouha]

Header 1	Header 2	Header 3	Header 4	Header 5