Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sort of Ranking is not working

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

1 Solution

Accepted Solutions
sunny_talwar

This isn't perfect... but see the attached

Capture.PNG

View solution in original post

10 Replies
annafuksa1
Creator III
Creator III

could you post your app ?

Not applicable
Author

Sorry, I can't

annafuksa1
Creator III
Creator III

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

adamdavi3s
Master
Master

What happens if you promote rank in the sort order?

Not applicable
Author

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

Not applicable
Author

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

thanks

Not applicable
Author

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

adamdavi3s
Master
Master

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?