Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This isn't perfect... but see the attached
could you post your app ?
Sorry, I can't
can you change/limited data and post app with only chart that cause problems ?
What happens if you promote rank in the sort order?
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
attached my sample model, where you can see that rank is not ordered
thanks
attached my sample model, where you can see that rank is not ordered
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?
Have you checked this doc: Perfectly Sorting Pivot Table (by A-Z. y-Value ... | Qlik Community ?