Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
hoangpm8
Not applicable

Pagination Table Qlik Sense

Hi All,


In my Qlik Sense report, I need to restrict number of records in table box.The requirement is like,my table contains 1 million records and I want to show 30 records at one see and provide list of numbers below,so that on click of 2, user can see next 30 records. Its like, achieveing paging in grid in asp.net. I found link: Straight Table Pagination | BI Experience, but it is QlikView.


Thanks,

Hoang

5 Replies
rsdhavle
Not applicable

Re: Pagination Table Qlik Sense

Please let me know if you find any solution for this. Even we are struggling with the same problem in Qliksense

yko
Not applicable

Re: Pagination Table Qlik Sense

Qlik Sense does use pagination for tables.

Perhaps it is the sorting that takes time? If this is the case, then you might want to try to move the sorting to the script, and use "sort by load order" on your dimensions.

Also, if you have any measures in your table, then I think it is likely that the computation of the "totals" value for those columns can be expensive for large tables.

rsdhavle
Not applicable

Re: Pagination Table Qlik Sense

i don't have any computation in my table. I am directly loading fields, also sorting i have kept it as it was default. My question was is there any way to control loading number of rows when user logs into dashboard like only 1-100 rows visible and then user can switch to next 101-200

dilipranjith
Not applicable

Re: Pagination Table Qlik Sense

You will need extensions. Dont think this is an out of the box functionality

yko
Not applicable

Re: Pagination Table Qlik Sense

Oh, sorry I misunderstood your question. I thought it was performance that was the issue. dilipranjith‌ is right, that type of clicking behavior for going to the next page will require an extension.