Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
EliGohar
Partner - Specialist
Partner - Specialist

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 - Specialist
Partner - Specialist
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!