- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- http://help.qlik.com/sense/2.1/en-us/developer/Subsystems/Platform/Content/Concepts/Paging.htm
Hope this helps!
Regards
Stefan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That was it, re-adding the visualization. Many thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It works fine!!