Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
EliGohar
Partner - Creator III
Partner - Creator III

Limit # of records in straight table

Hi All,

I'm having this table in my app:

EliGohar_0-1592402164532.png

 

This table might have around 300K records and I want to limit it for only 500 records.

All these fields are Dimensions, I couldn't use the limitation feature. 

Can you think about any trick that would do the magic?

And BTW I think it's a basic requirement to control number of records that I want to present in straight table...

Thanks,

Eli.

Labels (1)
5 Replies
lironbaram
Partner - Master III
Partner - Master III

Hi

while the isn't a built in paging in the table you can 

build one quite easily , it's not perfect , but still give the user control of the amount of data in the table 

have a look at the attach app 

 

EliGohar
Partner - Creator III
Partner - Creator III
Author

@lironbaram Thanks for sharing this creative idea but still no good enough for my purpose.

At the end I decided to work with an extension called Dynamic Table which does the job:

https://developer.qlik.com/garden/56728f52d1e497241ae69825

Eli.

mobeenbillah
Contributor II
Contributor II

@lironbaram 
I checked your Pagination, but according to requirement when we select page number like 2 then it should show record from 11 to 20. I hope you got my point.

 

Thanks

lironbaram
Partner - Master III
Partner - Master III

@mobeenbillah  I've modified the app have a look

 

josemaria_cabre
Contributor III
Contributor III

Simply awesome @lironbaram , great work!