top 10 records minimum

[cristianj23a]

Hola .

Quiero mostrar en una tabla sencilla con sólo 10 registros pero en mi mesa que muestra los 12 registros.

¿Cómo borro las últimas 2 vueltas?

tener en cuenta que los primeros 10 registros tienen que ser los mismos y los valores son de menor a mayor.

más o menos tiene que mostrarme como esto

Por favor me ayude con este tema.

Saludos

[tresesco]

Could you share your sample qvw or let know what expression/limit you have used that gives you these 12 values? For getting lowest values you can use negative ranking like: =Rank( -Sum(Sales))<=10

[cristianj23a]

Ready already I shared the qvw.

The code is little more complicated.

[prma7799]

Try this

https://community.qlikview.com/thread/62973

Remove the last row / Max Row

[dinuwanbr]

Hi Cristian,

You can do it in two ways.

1. You can limit the dimensions

2. You can use the rank () in your expression

Rank function in expression

Rank in the Qlikview - Qlikview for Life (Qlik4life)

How to use rank function?

Rgds,

Tharindu

[tresesco]

Could you share with the right expression? I don't see the same view you shared, in the qvw shared.

[cristianj23a]

Hi.

I entered the links but it is not what I am looking for.

[cristianj23a · Accepted solution]

Hi Tharindu.

I found the solution, it was simpler than I thought.

In properties / presentation select the maximum of records. In this case i entered 10 records.

Same thanks for the help.

Greetings.

[SANIGEST1]

Hi! Could you explain step by step the process to do the selection of the 10 values?

Thanks so much