topic Re: More than 10 rows/dimensions in QlikSense extension in Integration, Extension & APIs

More than 10 rows/dimensions in QlikSense extension

simondachstr — Wed, 14 Oct 2015 17:24:20 GMT

Hi community,

I hope this one is going to be straight forward and simple.

Taking the existing table-template.js file as an example I am trying to create a simple table extensions object. Everything works fine and I seem to be able to populate my HyperCube but only with up to 10 dimensions or metrics. I reckon this must be due to the defined attribute qWidth: 10, however extending it to more than that does not make any difference. It seems to me that a hypercube can only fetch a maximum of 10. Can someone confirm if this is true?

Furthermore, I thought, adding a second hypercube (based on the same underlying dataset) should solve the problem but here I am running in, to me, unknown areas. How do I properly populate the second hypercube (let's say with columns from 11-20 .e.g) and refer to them?

My requirement in summary: I am trying to display a table extension object with more than 10 dimensions/metrics. How do I approach it?

I appreciate any hints or examples if available.

Many thanks,

Martin

Re: More than 10 rows/dimensions in QlikSense extension

Stefan_Walther — Wed, 14 Oct 2015 17:37:16 GMT

Hi,

no you can define more than 10 columns, just extend qWidth (number of columns) and qHeight (number of rows). Note that you will (per data page) not get more than 10.000 cells, so if you have qWidth=10 you can enter a maximum of qHeight=1000

initialProperties: {
  qHyperCubeDef: {
  qDimensions: [],
  qMeasures: [],
  qInitialDataFetch: [
       {
       qWidth: 10,
       qHeight: 100
       }
  ]
  }
}

Re: More than 10 rows/dimensions in QlikSense extension

ErikWetterberg — Thu, 15 Oct 2015 06:31:16 GMT

Just an additional detail:

If you modify initialProperties and increase the qWidth, note that this will only affect new visualizations created after the change, so you need to recreate your visualization.

Erik

Re: More than 10 rows/dimensions in QlikSense extension

simondachstr — Thu, 15 Oct 2015 08:24:35 GMT

That was it, re-adding the visualization. Many thanks.

Re: More than 10 rows/dimensions in QlikSense extension

NZFei — Wed, 13 Jul 2016 05:08:11 GMT

Hello,

I have increased the qWidth to 20 but still there are only the first 10 columns that can display data. The columns from 11, I can add them to the table but the columns do not show any data. How to fix that?

Cheers.

Fei

Re: More than 10 rows/dimensions in QlikSense extension

ErikWetterberg — Wed, 13 Jul 2016 07:20:19 GMT

Have you tried adding a new table using your extension to the app? The initialProperties are applied when the table is created, so changing qWidth will not affect already existing tables.

Hope this helps!

Erik

Re: More than 10 rows/dimensions in QlikSense extension

mark_casselman — Fri, 22 Feb 2019 10:01:42 GMT

I also believe the number of dimensions is limited to 10.

I changed the inital properties, recreated the chart etc...

Every time I want to add an 11th dimension, I get a specific error message: "The calculation page is too large. Reduce the number of cells and try again.". I also tried reducing the number of rows, but the error remains.

Re: More than 10 rows/dimensions in QlikSense extension

tomovangel — Mon, 18 Mar 2019 12:43:55 GMT

Hi to all, I have fixed this for the following extension: https://github.com/stefanwalther/sense-export

there is a file which is called properties.js

In this file are defined the min and max properties of dimensions and measures. 🙂

By default they are 0-10 , so you can change them to whatever you like.

I am testing this with the following properties

dimensions: min-0 max-25

measures;min-0 max-50

And its working fine 😉 I just exported over 25 measures with 11 dimensions 🙂

BR, Angel Tomov

Re: More than 10 rows/dimensions in QlikSense extension

pakchangkyu — Wed, 25 Mar 2020 11:57:21 GMT

It works fine!!