Sort of Ranking is not working

[#1]

Hi,

I have done a table with a field defined as Ranking from 1 to 10 and I need to sort according this ranking, but nothing work.

I have 3 dimensions: T_Var (text), T_CName (text) and Rnk defined as:

=IF(Aggr(Rank(sum({$<T_Week={$(=Max(T_Week))}>}T_Amount)),T_Var,T_CName) <= 10, Aggr(Rank(sum({$<T_Week={$(=Max(T_Week))}>T_Amount)),T_Var,T_CName),Null())

Max(T_Week) = 201708

The expressions are sum(debt) for last 10 weeks.

And when I sort the dimensions, T_Var is ascending text, TCName is like gollowing print screen and Ranking doesn't have sort rule:

Can you help me, telling me why the result is not sorting by Ranking:

thanks

[annafuksa1]

could you post your app ?

[#3]

Sorry, I can't

[annafuksa1]

can you change/limited data and post app with only chart that cause problems ?

[adamdavi3s]

What happens if you promote rank in the sort order?

[#6]

I can't promote rank in the sort order because it is a dimension... and if I promoted in the dimension definition I have trouble with the customer ranK of top 10

[#7]

attached my sample model, where you can see that rank is not ordered

thanks

[#8]

attached my sample model, where you can see that rank is not ordered

[adamdavi3s]

Hi Nancy,

I've tried a lot of things but I can't get this to work I am afraid, I think its just the way pivots work.

However someone like stalwar1‌ might have a better idea?

[tresesco]

Have you checked this doc: Perfectly Sorting Pivot Table (by A-Z. y-Value ... | Qlik Community ?