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.
That is not an option in a standard table box. It sounds like a sensible thing for someone to build an extension to do though. I've not seen one though.
@Micheal Solomovich..thanks for reply and providing nice solution.But i want to use it in table box.i I have added interactive sorting,which is by default provided by table box object.In addition of these,I have provided 3 filetrs(list boxes) in my report.can we achieve all this,with this paging.Could you please provide some solution for this.
My solution doesn't allow interactive sorting. See if the solution, to which Gysbert Wassenaar pointed, allows it.
Table box - it doesn't allow calculated dimensions, hence my solution is not applicable. But visually there is no much difference between table box and straight table, so you can use the table.
Filtering - yes, you can use it, it doesn't break paging.
ohk...using straight table or table box is not a big concern.But I need to implement interactive sorting.yes,i will try to implement Gysbert and check it.Till then ,If you can modify or create some qvd which implements my requirement,then I will be greatly thankful to you.
