Is it possible to limit the number of rows in a straight table?

[#1]

For instance, I have total 50 records in my table and I want to show only top 10 records based on the rank. How can I achieve this?

[beck_bakytbek]

Hi Anand

do you want to Show only Top 10 Records? if yes, you can create calculated Dimension where you Show only top 10 Records.

beck

[Clever_Anjos · Accepted solution]

Go to Dimension Limits, you can create several rules about limiting your table

[#4]

can you please elaborate beck? Yes, I need only top 10 records. I am able to show in chart but not the same in table if I use both objects in my canvas.

[Karim_Khan]

yes u can achieve the same through dimension limits option

[Karim_Khan]

Through rank u will ge the exact value for what ur looking?it depends upon the requirment?

[beck_bakytbek]

Hi Anand,

give please more Information to your issue so that we can provide right suggestions/solution

beck

[Anonymous]

Hi

Simple way we can show top 10 based on Rank is

Go to Chart Properties>Dimension Limits>Tick Restrict values> Largest 10

Or else if you want to give option to user to limit the rows in straight table, you can create one variable and use that variable in Slider Object

Or else by using Rank Function

Hope it helps!!

[jonas_rezende]

Hi, anand sinha.

See if the post helps https://community.qlik.com/message/793977#793977.

[Anonymous]

use dimension limits in chart properties