topic Re: Sort of Ranking is not working in QlikView

Sort of Ranking is not working

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Sort of Ranking is not working

annafuksa1 — Thu, 02 Mar 2017 13:14:47 GMT

could you post your app ?

Re: Sort of Ranking is not working

Thu, 02 Mar 2017 13:18:51 GMT

Sorry, I can't

Re: Sort of Ranking is not working

annafuksa1 — Thu, 02 Mar 2017 13:21:54 GMT

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

Re: Sort of Ranking is not working

adamdavi3s — Thu, 02 Mar 2017 13:31:33 GMT

What happens if you promote rank in the sort order?

Re: Sort of Ranking is not working

Thu, 02 Mar 2017 14:43:07 GMT

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

Re: Sort of Ranking is not working

Tue, 07 Mar 2017 20:00:12 GMT

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

thanks

Re: Sort of Ranking is not working

Tue, 07 Mar 2017 20:01:00 GMT

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

Re: Sort of Ranking is not working

adamdavi3s — Wed, 08 Mar 2017 07:34:16 GMT

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?

Re: Sort of Ranking is not working

tresB — Wed, 08 Mar 2017 10:47:31 GMT

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

Re: Sort of Ranking is not working

sunny_talwar — Wed, 08 Mar 2017 11:01:02 GMT

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