Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

Show Top 5 Movies In A Text Box

I know how to do this in a table as it's a simple fix, but was wanting to display in a text box.  Table is as follows:

IMDb Top 100 Rating:           Show

1                                             Westworld

2                                             The Handmaid's Tale

4                                             Game of Thrones

7                                             Homeland

10                                           The 100


Tags (1)
1 Reply
Valued Contributor II

Re: Show Top 5 Movies In A Text Box


concat( if(aggr(rank(sum( your measure)),show) <=5,show),'\n')

or if you want in order and with position :

FirstSortedValue(Vendeur,-aggr(rank(sum( Prix)),Vendeur),position)