Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Limit the number of records displayed in the Table box

Hi,

Is there a way to limit the number of records displayed initially in the table box?

Thanks,

Karthick S

4 Replies
krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi Karthick,

You cant limit the record in Table Box. You should restrict the limit in Script.

Other choice is to convert the table box to straight table and limit the records.

Anonymous
Not applicable
Author

Thanks Krishnapriya. Eventhough we use straight table, we can limit the records only to 100, right?

vinieme12
Champion III
Champion III

Don't use a table box use a straight table, add an expression with set criteria for the records you want to restrict, simple!!

Example = if (year=2016,1)   ..... Now the straight table is filtered to show only records for year 2016

Let's us know if you are having difficulty with the expression

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
krishnacbe
Partner - Specialist III
Partner - Specialist III

I didn't get what is 100 records limitation. It is not the case. you can view all the records.