topic Re: Ranking in QlikView

Ranking

omarlq20 — Fri, 07 Dec 2012 22:24:11 GMT

Srs podrian ayudarme a realizar este ranking debe estar ordenado por las dimensiones Tienda, Categoria, y Producto

Mrs, could help me with this ranking should be ordered by the dimensions Tienda, Categoria, y Producto

Re: Ranking

swuehl — Fri, 07 Dec 2012 22:40:01 GMT

Not quite sure what you expect as result, could you post the expected outcome?

Or maybe try this:

=rank(total sum(Stock))

Re: Ranking

Tue, 14 May 2013 12:09:32 GMT

take the opportunity to consult a doubt with the example of the stores.

I need the ranking of the store that sold more, but omitting the other dimensions of the graph. This means, the store that sells more want a repeat of the one in each of their records.

Attache a Excel File with expected result.

Re: Ranking

kumarnatarajan — Tue, 14 May 2013 12:16:14 GMT

Hi,

Try This one

EX: Aggr(NODISTINCT Rank(Sum(Stock)),Producto)

Re: Ranking

Tue, 14 May 2013 12:50:06 GMT

Thanks Kumar.

In my example is

Aggr(NODISTINCT Rank(Sum(Stock)),Tienda)