topic Re: How to get more than 1000 rows in qHypercube -> qDataPages in Integration, Extension & APIs

How to get more than 1000 rows in qHypercube -> qDataPages

rohanas1701 — Mon, 20 Nov 2023 14:42:24 GMT

Hi All,

I am trying to build a button extension to get excel export of multiple tables into single excel using object ID's.

I am taking input as ObjectID, and in backend JS using below code to create a qlik Table object -

var app = qlik.openApp( appName, config);
app.getObject("QV01",objIdE).then( function( object ) {

var qTable = qlik.table(object);

console.log(qTable);

}

On the console, when I traverts to qDataPages , I can able to see 1000 rows of data there ,but My table is having more than 1000 records.

qSize is giving me correct size i.e qSize: {qcx: 2, qcy: 1647}

I searched about it and find few recommendations to adjust the InitialProperties . I have given qWidth :4 and qHeight 2500 there, still no luck.

And Secondly , if I try to implement it with backendAPI functions mentioned in documentation, i am not able to associate proper this reference , because the main object is Button and not the table.

Please help how can I get more than 1000 rows.

Re: How to get more than 1000 rows in qHypercube -> qDataPages

vincent_ardiet_ — Mon, 20 Nov 2023 15:15:46 GMT

There is a limit of 10.000 cells, you will need to paginate, see https://help.qlik.com/en-US/sense-developer/August2023/Subsystems/APIs/Content/Sense_ClientAPIs/CapabilityAPIs/TableAPI/getMoreData-method.htm

Re: How to get more than 1000 rows in qHypercube -> qDataPages

rohanas1701 — Wed, 22 Nov 2023 09:47:57 GMT

Could you please help with sample code. The documentation is not very explanatory.

Re: How to get more than 1000 rows in qHypercube -> qDataPages

ajaykakkar93 — Wed, 22 Nov 2023 09:57:07 GMT

Hi,

Please follow the below link.

https://qlik.dev/extend/build-extension/get-additional-data

Re: How to get more than 1000 rows in qHypercube -> qDataPages

rohanas1701 — Wed, 22 Nov 2023 12:32:34 GMT

Hi Ajay,

I tried this method, but it only works if my extension object itself is a table (self).

In my case, i am building a button which passes the list of table object id's and with that , it fetches the records. Hence ,there i cant use self.backendApi (bcoz in my case, self is button and not table)

Re: How to get more than 1000 rows in qHypercube -> qDataPages

Adam_Romanowski — Wed, 22 Nov 2023 12:47:01 GMT

If you change InitialProperties in extension already placed on the sheet, you must "replace" old visualization with updated extension - even if it's the same name.

So in edit mode drag your extension with updated InitialProperties and drop on already placed visualization on the sheet.

Re: How to get more than 1000 rows in qHypercube -> qDataPages

ajaykakkar93 — Thu, 23 Nov 2023 01:02:35 GMT

Ok, Tell me your entire usecase, this isn't the full usecase. i may be able to help you

topic Re: How to get more than 1000 rows in qHypercube -&gt; qDataPages in Integration, Extension & APIs

How to get more than 1000 rows in qHypercube -> qDataPages

Re: How to get more than 1000 rows in qHypercube -> qDataPages

Re: How to get more than 1000 rows in qHypercube -> qDataPages

Re: How to get more than 1000 rows in qHypercube -> qDataPages

Re: How to get more than 1000 rows in qHypercube -> qDataPages

Re: How to get more than 1000 rows in qHypercube -> qDataPages

Re: How to get more than 1000 rows in qHypercube -> qDataPages

topic Re: How to get more than 1000 rows in qHypercube -> qDataPages in Integration, Extension & APIs