Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

New Contributor II


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

4 Replies

Re: Ranking

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

Or maybe try this:

=rank(total sum(Stock))

Not applicable

Re: Ranking

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.

Valued Contributor

Re: Ranking


Try This one

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

Not applicable

Re: Ranking

Thanks Kumar.

In my example is

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