topic Re: CREATE A TABLE WITH TOP 5 ONLY APPEARS in App Development

CREATE A TABLE WITH TOP 5 ONLY APPEARS

philgood34 — Wed, 18 Oct 2017 14:49:46 GMT

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 — Wed, 18 Oct 2017 15:12:30 GMT

i just found the answer in this thread :

truly sorry

Regards

Philippe

matteo_mi — Wed, 18 Oct 2017 15:19:20 GMT

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 — Wed, 18 Oct 2017 15:55:13 GMT

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