topic Re: Sort a rank in QlikView

Sort a rank

Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I have a pivot table with one dimension = rank (1 to 10).

This rank =IF(Aggr(Rank(sum({$<Week={$(=Max(Week))}>}Amount)),Var,CName) <= 10,Aggr(Rank(sum({$<Week={$(=Max(Week))}>}Amount)),Var,CName),Null())

The order of dimensions is Var (No sort), CName sort by expression = sum({$<Week={$(=Max(Week))}>}Amount) , Rank (No sort).

However, ranking sort is not working.

any help????

Thanks

Re: Sort a rank

Anonymous — Tue, 07 Mar 2017 18:34:59 GMT

did you try to sort by expression:

Aggr(Rank(sum({$<Week={$(=Max(Week))}>}Amount)),Var,CName)

Re: Sort a rank

Tue, 07 Mar 2017 18:55:25 GMT

It's no working

Re: Sort a rank

vishsaggi — Tue, 07 Mar 2017 19:07:41 GMT

can you share your sample to look into?

Re: Sort a rank

Tue, 07 Mar 2017 19:53:50 GMT

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

Thanks

Re: Sort a rank

Tue, 07 Mar 2017 19:54:37 GMT

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

thanks !

Re: Sort a rank

Anonymous — Tue, 07 Mar 2017 20:24:23 GMT

I think you have to promote the rank to the top of the sorting levels. Means rank must be the first dimension.

This is the way how pivots work. Everything is grouped and within one group (dimension) the next sorting will be applied.

Re: Sort a rank

Tue, 07 Mar 2017 20:30:28 GMT

Nop. This not working... these happen when I promoted the rank to the top:

Help!!!

Re: Sort a rank

Anonymous — Tue, 07 Mar 2017 20:44:21 GMT

Did you set the sort order of "RNK" to numeric ascending?

Is RNK now on the top level of your sort order?

Re: Sort a rank

Tue, 07 Mar 2017 20:59:29 GMT

In the print screen above rank is the first dimension and I loose the ranking by Variable...

Re: Sort a rank

vishsaggi — Tue, 07 Mar 2017 21:12:17 GMT

I am not sure there is something happening with your Customer Field? Check attached.

Re: Sort a rank

Wed, 08 Mar 2017 12:27:15 GMT

Thanks a lot!!!