topic Re: Qlik Sense JS Extension createTable() does not return values in Integration, Extension & APIs

Qlik Sense JS Extension createTable() does not return values

Anonymous — Fri, 26 Jan 2018 07:17:28 GMT

Hi,

I have some trouble with creating table in Qlik Sense extension.

If I wrote:

let object = app.createTable(dimensions,{rows:1000});

console.log('object: ', object);

Promise.all([object]).then(function(values){

console.log('rows: ', object.rows);

console.log('qHyperCube: ', object.qHyperCube);

});

I get

Witch I don't understand:

- we can see that when I print whole object I can see rows (and they are right) and qHyperCube witch has same rows inside.

- But when I wan't to extract this information I get empty array/undefined object

- I understand that createTable only return promise,....

How do you do this?

Marko Zadravec

Re: Qlik Sense JS Extension createTable() does not return values

ErikWetterberg — Fri, 26 Jan 2018 09:54:28 GMT

Hi,

You need to wait for the OnData event before the rows are actually available.

The fact that you see them in the console is because Chrome doesnt check inside the object until you click on the arrow, at which time the data will be available.

Hope this helps

Erik Wetterberg

Re: Qlik Sense JS Extension createTable() does not return values

Anonymous — Fri, 26 Jan 2018 11:21:41 GMT

Yes this is true,

I figure out that I need to bind observer to table, to check when data come.

I don't know why, but Promise.all doesn't work.

Re: Qlik Sense JS Extension createTable() does not return values

ErikWetterberg — Fri, 26 Jan 2018 12:04:11 GMT

Promise.all does work, but the promise resolves when the table object is available, which is earlier than it has data, the framework needs to call getLayout to get the data.

Erik Wetterberg

Re: Qlik Sense JS Extension createTable() does not return values

sanket_raj — Wed, 12 Dec 2018 20:16:35 GMT

How did you bind observer to table? I tried using below code but it is not working:

var table = qlik.table( this ); var listener = function() { var rowCount = table.rowCount; var colCount = table.colCount; table.OnData.unbind( listener ); //unregister the listener when no longer notification is needed. }; table.OnData.bind( listener ); //bind the listener