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: 
Not applicable

How to limit data in table box

Hello All,

We want to show a static number of 1000 records only in a table box.

Whole data set : 30 million records

How to limit the same in table box?

Is there any option?

Thanks!

6 Replies
Anonymous
Not applicable
Author

Use a Straight Table instead and use the Dimension Limits to only show first 1,000 rows.

rajkumarb
Creator II
Creator II

Hi,

Set Analysis is better option.

sudeepkm
Specialist III
Specialist III

do you want the customer to just see the first 1000 records or

1000 records at a time and then next 1000 records until all records like pagination?

Not applicable
Author

Hi

Try this data

By Set Analysis function in the Straight / pivot Charts

Check this Thread below

Set Analysis: syntaxes, examples

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

If you're using straight table then go to Properties -> Calculation Condition -> Click on ellipsis (...) -> enter = Dimension_Primary_Key <= 1000. Click OK.

Note :


Dimension_Primary_Key has to be filed which identifies each row in the table.

This is give you want you want to achieve.

Not applicable
Author


Hello All,

The requirement is on a table box alone.

Is there any way to do it, without going for a straight table?

Thanks!