Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

philgood34
Contributor II

CREATE A TABLE WITH TOP 5 ONLY APPEARS

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

1 Solution

Accepted Solutions
philgood34
Contributor II

Re: CREATE A TABLE WITH TOP 5 ONLY APPEARS

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

3 Replies
philgood34
Contributor II

Re: CREATE A TABLE WITH TOP 5 ONLY APPEARS

i just found the answer in this thread :

Qlik Sense Top 10 Ranking

truly sorry

Regards

Philippe

matteo_mi
New Contributor II

Re: CREATE A TABLE WITH TOP 5 ONLY APPEARS

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
Contributor II

Re: CREATE A TABLE WITH TOP 5 ONLY APPEARS

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