topic Paging in Table box in QlikView

Paging in Table box

Fri, 21 Feb 2014 15:54:40 GMT

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

Re: Paging in Table box

Gysbert_Wassenaar — Fri, 21 Feb 2014 15:58:57 GMT

See this blog post: YA(H)Q Blog: Paged charts in Qlikview

Re: Paging in Table box

stevedark — Fri, 21 Feb 2014 16:00:59 GMT

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.

Steve

Re: Paging in Table box

stevedark — Fri, 21 Feb 2014 16:02:28 GMT

Good call Gysbert. I hadn't seen that post before.

Re: Paging in Table box

Anonymous — Fri, 21 Feb 2014 17:10:18 GMT

Here is an example, at the end: http://community.qlik.com/message/451096#451096

Re: Paging in Table box

Fri, 21 Feb 2014 19:47:37 GMT

@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.

Re: Paging in Table box

Anonymous — Fri, 21 Feb 2014 20:21:38 GMT

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.

Re: Paging in Table box

Fri, 21 Feb 2014 20:28:24 GMT

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.

Re: Paging in Table box

Anonymous — Fri, 21 Feb 2014 20:57:13 GMT

Hi Tushar,

This may help Paging Implementation for Straight table

Re: Paging in Table box

Sat, 22 Feb 2014 19:34:29 GMT

Hey guys any update regarding my query?

Re: Paging in Table box

Sat, 22 Feb 2014 20:10:37 GMT

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

Re: Paging in Table box

Sat, 22 Feb 2014 20:13:13 GMT

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

Re: Paging in Table box

hic — Sun, 23 Feb 2014 19:23:43 GMT

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

Re: Paging in Table box

Mon, 24 Feb 2014 04:16:44 GMT

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

Re: Paging in Table box

hic — Mon, 24 Feb 2014 07:00:13 GMT

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

Re: Paging in Table box

Mon, 24 Feb 2014 08:09:24 GMT

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.

Re: Paging in Table box

stevedark — Mon, 24 Feb 2014 08:23:14 GMT

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

Re: Paging in Table box

Mon, 24 Feb 2014 08:26:14 GMT

hi tushar,

please have look at this blog hope this Helps

Paging Implementation for Straight table

Re: Paging in Table box

Mon, 24 Feb 2014 09:36:01 GMT

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.

Re: Paging in Table box

Anonymous — Mon, 24 Feb 2014 13:32:59 GMT

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.