More than 10 rows/dimensions in QlikSense extension

[simondachstr]

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

[Stefan_Walther]

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
       }
  ]
  }
}

Read more here:

- qliksense-extension-tutorial/08-Hello-Data.md at master · stefanwalther/qliksense-extension-tutorial...

- qliksense-extension-tutorial/1002-Troubleshooting-FAQ.md at master · stefanwalther/qliksense-extensi...

- http://help.qlik.com/sense/2.1/en-us/developer/Subsystems/Platform/Content/Concepts/Paging.htm

Hope this helps!

Regards

Stefan

[ErikWetterberg · Accepted solution]

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

[simondachstr]

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

[NZFei]

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

[ErikWetterberg]

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

[mark_casselman]

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.

[tomovangel]

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

[pakchangkyu]

It works fine!!