topic Getting data from chart hypercube in App Development

Getting data from chart hypercube

maxim1500 — Thu, 02 Feb 2017 14:02:31 GMT

Hi,

I am trying to get the raw data from the chart model. For most of the charts, the data gets filled into qHyperCube.qDataPages. But for widgets such as stacked barcharts and tables, it always stays empty.

I tried getting the data using the QTable api, using:

        var table = qlik.table(model);
        var listener = function () {
            console.log("data binded");
        };
        table.OnData.bind(listener);

But the listener is never called.

Is there another way of getting the data for those widgets?

Thanks!

Re: Getting data from chart hypercube

maxim1500 — Thu, 02 Feb 2017 14:15:23 GMT

Found the answer in this post:

Get data from table or chart

// Fetch a page of data. A single page can maximum contain 10000

// cells. Calculate the page size and number of pages based of qSize

// and fetch accordingly.

model.getHyperCubeData('/qHyperCubeDef', [{

qTop: 0,

qLeft: 0,

qWidth: 10,

qHeight: 1000

}]).then(data => console.log(data))

Re: Getting data from chart hypercube

sebastian_serva — Fri, 22 Sep 2017 01:26:32 GMT

Hi Maxime,

Does your promise execute every time there's a model change? (ie when selections change).

Seb