Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

RANKING

Hi,

Let's imagine we have two fields: Articles and Sales.

Ventas_Articles.pngtabla.png

The objective is to create a Text Object that says the rank position of each Article (in terms of Sales), meaning that when we select the Article=A we want to see our text object saying:7 as is it shown into the right table. The current problem with the right table is that when we select one Article, the rank is always 1, no matter what article is selected.

taula2.png

Thank you in advance!

1 Solution

Accepted Solutions
maxgro
MVP
MVP

try

aggr(rank(sum({<Article=>} Ventas)), Article)

View solution in original post

4 Replies
maxgro
MVP
MVP

try

aggr(rank(sum({<Article=>} Ventas)), Article)

ecolomer
Master II
Master II

Is this you need?

Not applicable
Author

I've used set analysis in "Article" to ignore its selection.

Good luck!

Not applicable
Author

THANK YOU!