Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
rohanas1701
Contributor II
Contributor II

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

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. 

 

Labels (3)
6 Replies
vincent_ardiet_
Specialist
Specialist

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/Capa...

 

rohanas1701
Contributor II
Contributor II
Author

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

ajaykakkar93
Specialist III
Specialist III

Hi,

Please follow the below link.

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

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

rohanas1701
Contributor II
Contributor II
Author

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)

 

Adam_Romanowski
Partner - Contributor III
Partner - Contributor III

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.

ajaykakkar93
Specialist III
Specialist III

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

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting