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]

hello Micheal ,I got solution at following link.But not able to find out ,how jagan restrict clear button.Also i have created slider control on Group field ,so that numbers can be used as page index and user can directly navigates to particular page no.But on click of clear button,all records are shows.Now I have to restrict this thing only.

Paging Implementation for Straight table

[Anonymous]

Tushar,

I think you have to add property "Always one select value" to the Group field.

Anyway, I don't see working interactive sort there, as I've just said.  Unless you figured out and made some changes.

Regards,

Michael

[#4]

hi tushar,

i think your problem is solved

so u can mark this question as answered  so it will be helpful for other those who are searching for for Paging in straight table

thanks

[#5]

Interactive sorting is working there.But Micheal where I have to add this property?I have try it.but didnt find where to add it in my table box?

[Anonymous]

Tushar,

Select one value in the Group field, and after that go to the list box properties.  Check the box "Always One Selected Value".

As for the interactive sort - I mean it works by itself (it was never a problem), but paging doesn't work correctly with sorting by most fields in the example.  It works only if you sort by Group or by IP Address.

Regards,

Michael

[#7]

Ohk thanks...micheal..but now I have changed list box to slider as I want to show a horizontal line to show a series of numbers to navigate the particular page index.so I use slider now.now how we use fix always select one in that.also interactive sort ia wworking in this example.now I just have to verify that is it working fine or not.will reply here after test that.yoy plz tell how we can fix always select one in slider.is it possible that I use list box and use select one in this and make list box hide...

[Anonymous]

If you use a slider based on the same field, you can create a list box, apply "always..." as I've described, and hide or even delete the list box.