Hypercube

[brindlogcool]

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.

[ErikWetterberg]

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

[brindlogcool]

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

[brindlogcool]

We are using the Enterprise 3.0 Version

[vvvvvvizard]

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.

[brindlogcool]

Hi Rawat/Erik,

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

[brindlogcool]

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

[ErikWetterberg]

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

[brindlogcool]

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

[ErikWetterberg]

Hi,

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

Erik Wetterberg