Paging

Paging is a concept used in Qlik Sense to allow access to selected parts of data tables.

The number of table rows returned by hypercubes and list objects can in many case become very large, and it will often be impractical to retrieve all cells of the table in a single call to engine. A typical application of paging would be to populate a list box in a GUI. The GUI can know up front how many rows it will be able to display, and scrolling through a list box containing millions of rows could quickly suffer from performance problems unless a paging strategy is implemented.

The structure NxPage is used to define a page. The structure contains the properties Top, Left, Height, and Width, which together define a rectangle of cells within a table. For instance, NxPage structures are provided as arguments to the engine for methods that get data from hypercubes and list objects, and those methods return data in the form of NxDataPage structures. The NxDataPage structure contains a matrix representing the rows and columns of the data returned as well as metadata concerning the data that was returned.

The methods provided by the engine (for instance GenericObject.GetData) take lists of pages as arguments, which makes it possible to retrieve multiple pages in one call. A typical application of this is to get both the first and the last few rows of a table to make it possible to implement a smooth scrolling behavior in a component that allows scrolling to wrap around to the top.

Example: Get the second and third row from the table below

NxPage to use: { Top = 1, Left = 0, Height = 2, Width = 3 }

Result

Year	Month	Sum(Sales)
2014	February	101412
2014	March	90233

Example: Get Month and Sales (but not Year) from the first 5 rows of the table below.

NxPage to use: { Top = 0, Left = 1, Height = 5, Width = 2 }

Result

Month	Sum(Sales)
January	101235
February	101412
March	90233
April	128923
May	154321

Example: Get the first 2 and last 2 rows of the table below.

NxPages to use: [{ Top = 0, Left =0, Height = 2, Width = 3 }, { Top = 14, Left =0, Height = 2, Width = 3 }]

Result

Year	Month	Sum(Sales)
2014	January	101235
2014	February	101412

Result

Year	Month	Sum(Sales)
2015	March	112455
2015	April	105567

Example: Source data

Dimensions	Measures	-
Year	Month	Sum(Sales)
2014	January	101235
2014	February	101412
2014	March	90233
2014	April	128923
2014	May	154321
2014	June	112552
2014	July	192134
2014	August	90213
2014	September	90576
2014	October	90227
2014	November	106311
2014	December	112394
2015	January	145621
2015	February	174566
2015	March	112455
2015	April	105567