topic Re: Hypercube in Integration, Extension & APIs

Hypercube

brindlogcool — Mon, 10 Jul 2017 04:36:22 GMT

Is there any limitation on the number of rows and columns in the Hypercube. I am not able to show more than 20 columns and 200 rows.

Re: Hypercube

ErikWetterberg — Mon, 10 Jul 2017 05:20:22 GMT

Hi,

No there is not such a limit, but there is a limit on the number of rows you can get with the first call. You need to make additional calls to get more data than that:

GetHyperCubeData method ‒ Qlik Sense

Hope this helps

Erik Wetterberg

Re: Hypercube

brindlogcool — Mon, 10 Jul 2017 09:49:10 GMT

I am getting the error as : Cannot read property 'qMatrix' of undefined if the columns is more than 20 is there any example to pull all the rows and columns in the hyper cube

Re: Hypercube

brindlogcool — Mon, 10 Jul 2017 09:49:52 GMT

We are using the Enterprise 3.0 Version

Re: Hypercube

vvvvvvizard — Mon, 10 Jul 2017 10:48:52 GMT

If you have lots of rows in your data table, then Qlik will split the ‘hypercube’ into separate pages so the data doesn’t crash the browser when the page is first loaded.Qlik will only bring back the first page of data in the initial paint of the extension, each page can have up to 10,000 cell values (columns*rows). This means you need to either make sure the extension can function with either just the first page or you will need to loop through each page and extract the data.

Re: Hypercube

brindlogcool — Mon, 10 Jul 2017 11:25:14 GMT

Hi Rawat/Erik,

Thanks for the response. But the problem is the qDatapages become blank(No Values) when the columns are 98.

Re: Hypercube

brindlogcool — Mon, 10 Jul 2017 11:44:59 GMT

To be specific it allows till qWidth to 50. If it is more than 50 then then the qDatapages is blank.

Re: Hypercube

ErikWetterberg — Mon, 10 Jul 2017 12:02:05 GMT

Hi,

The limit is on the number of cells, so how many columns you can have depends on how many rows you have. If you have many columns you need to cut down on the number of rows.

How to get more rows depends on the context. Basically it is the method I refered to above (

GetHyperCubeData method ‒ Qlik Sense‌) but there are a number of methods you can use that simplifies for you:

getData method ‒ Qlik Sense

getMoreData method ‒ Qlik Sense

Erik

Re: Hypercube

brindlogcool — Mon, 10 Jul 2017 13:31:49 GMT

Thanks, Erik

I am trying to understand the column row dependency is there any document to define the if we have x number of columns then you can have y no of rows or it has to be checked by trail and error

Re: Hypercube

ErikWetterberg — Tue, 11 Jul 2017 06:47:13 GMT

Hi,

Not hat I know of, if you do find any documentation on this, please share.

Erik Wetterberg