Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
simondachstr
Luminary Alumni
Luminary Alumni

More than 10 rows/dimensions in QlikSense extension

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

1 Solution

Accepted Solutions
ErikWetterberg

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

View solution in original post

8 Replies
Stefan_Walther
Employee
Employee

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

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
Luminary Alumni
Luminary Alumni
Author

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

NZFei
Partner - Specialist
Partner - Specialist

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
Creator
Creator

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
Partner - Specialist
Partner - Specialist

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
Partner - Contributor II
Partner - Contributor II

It works fine!!