How to set limit to a table chart

[Anonymous]

Hello qlikers 🙂 ,

I have a chart table.  I only want 5 rows. How could I set a limit to the chart? I only find solution in the load script, but I want it directly in the chart.

Thank you in advance! 🙂

EDIT:

=aggr(if(rank([Time] ,-[Time] )<=5, [Time] ),[ID],[Time], [Title] )

I have this, but it shows me all values. 

https://community.qlik.com/t5/New-to-Qlik-Sense/limiting-and-ranking-data-on-a-simple-table-based-on... 

[lorenzoconforti · Accepted solution]

This depends on your visualization but try:

=aggr(if(rank([Time] ,-[Time] )<=5, [Time] ),[Time] )

Also make sure you unselect include null values in your dimension