topic Re: How to access ALL data from an object in QlikView

How to access ALL data from an object

tschollqlikview — Mon, 26 Jan 2026 16:26:21 GMT

Hey there,

I have a problem to access data from a large table via an extension.

When I want to access the data, I can only read the first 40 rows, although the table has hundreds of rows.

My code is as follows:

var lb = doc.GetObject("TB01"); // the table object

lb.SetOnUpdateComplete(function() { // when data is loaded

console.log(lb.Data.Rows.length]); // always 40

for (var i = 0; i<lb.Data.Rows.length; i++) {

//…..

}

});

Does anyone have a clue, how to access the data of the 41th …XXth row?
Thx

Re: How to access ALL data from an object

Fri, 16 Sep 2016 06:12:02 GMT

Try this one,

qva.GetQvObject("TB01",getTblData); // the  table object

function getTblData()
{
  var _this = this;
  var tblName = _this.Name;

  var totalRows = _this.Data.TotalSize.y; // get totalRows
  var currRows = _this.Data.PageSize.y; // get current rows (always less than 40)

  if(totalRows > currRows){ // if totalRows > 40
    _this.Data.SetPagesize(_this.Data.TotalSize);
    qva.GetQvObject(tblName, getTblData);
    return;
  }

  var data = _this.Data;

  //reset the page size
  _this.Data.SetPagesizeY(40);
  _this.Data.SetPagesizeX(40);

  for (i = 0; i < data.Rows.length; i++)
  {
  //Your code
  }
}

Re: How to access ALL data from an object

nabhiram — Mon, 19 Sep 2016 04:08:07 GMT

I had similar issue, I tried this

It's working for me

Thanks for your help BGN

Re: How to access ALL data from an object

adamdavi3s — Mon, 19 Sep 2016 10:34:30 GMT

What is your pageheight in the definition.xml?