Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
karthick01
Contributor III
Contributor III

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
Partner

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.

karthick01
Contributor III
Contributor III
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
Partner

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