CREATE A TABLE WITH TOP 5 ONLY APPEARS

[philgood34]

HI everybody

What is the exact expression to create a table in Q SENSE  to provide visualization where appears only the top 5 SALES ?

DIMENSION = categories

MEASURE = Sales

thank's by advance

Philippe

[philgood34]

i just found the answer in this thread :

Qlik Sense Top 10 Ranking

truly sorry

Regards

Philippe

[matteo_mi]

Hi Philippe,

you can do that easily by limit the dimensions during modify chart.

In the dimension box you have available limits and you can choose to limit 5 top or bottom and to show or not to show the others value as unit value.

I hope this help you

[philgood34 · Accepted solution]

Hi Matteo

i did'nt knew that 🙂

now i have the choice

Dimension Box or

=Sum({<CATEGORIES = {"=Rank(Sum(SALES))<=5"}>} SALES)

Easy !

Thank's

regards Philippe