Paging in Table box

[#1]

Hello Guys,

In my qlikview report, I need to restrict number of records in table box.The requirement is like,my table contains 100 records and I want to show 10records at one see and provide list of numbers below,so that on click of 2,user can see next 10 records.Its like ,achieveing paging in grid in asp.net.Or you can take example of google also,as we search on google,it shows some result on page and then show a series of number below,so that user can navigate to next 2nd ,3rd page of result.

How we can achieve this in qlikview table box.

Hey guys ,I have added a sample file.In this table box contains 9 records.But my requirement is like,i need to show 3 records by default on table box and need to provide some button(to navigate to next page) or set of @ number(1 2 3 4....so that user can navigate to those set of 3records).

Also if some selections made from list box,and more than 3 records filters out then it also come in paging.

Message was edited by: Tushar Sharma

[#2]

nitha thanks for reply.but in this example on click of clear all records are starts showing.which breaks pagination.

[#3]

Thanks for reply Gysbert  but  this exaample breaks interactive sort.also i need tshow simply table in report,no chart,no count or sum.

[hic]

Jonathan Dienst's solution on YA(H)Q Blog seems to be a good one. Further, just as a few others above say, I'd also say that it isn't possible to achieve with a table box. So, you need to use a straight table.

HIC

[#5]

Ohh.thanks for reply henric...but how we can achieve inreractive sort with it..

[hic]

A straight table has, by default, interactive sort. You need to make sure that each column has a sort order defined, and you need to make sure that "Sort Indicator" on the Presentations tab is checked.

HIC

[#7]

But Henric.In this blog,they restrict interactive sorting .Could you plz upload a sample for paging with interactive or make changes in my test file.

[stevedark]

Hi Tushar,

You may find that you can get an interactive sort by using an Expression sort and a button to change a variable to alter the expression.  There are some thoughts over on this thread: Re: dynamical change sort order

- Steve

[#9]

hi tushar,

please have look at this blog hope this Helps

Paging Implementation for Straight table

[#10]

Thanks for reply. I have already chekc thta blogs.itis very good.but is has some flaws.I have shared my comments on this blog.

[Anonymous]

Unfortunately the interactive sorting doesn't work in this example.  The sorting Group is created by IP Address.  If you sort the table by 9WKS, 1WK, or 07WKS, the paging is wrong.