Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Luminary
Luminary

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
erik_wetterberg
Honored Contributor

Re: More than 10 rows/dimensions in QlikSense extension

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

Erik Wetterberg
https://extendingqlik.upper88.com/
5 Replies
Employee
Employee

Re: More than 10 rows/dimensions in QlikSense extension

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

erik_wetterberg
Honored Contributor

Re: More than 10 rows/dimensions in QlikSense extension

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

Erik Wetterberg
https://extendingqlik.upper88.com/
Luminary
Luminary

Re: More than 10 rows/dimensions in QlikSense extension

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

xufei123
Valued Contributor

Re: More than 10 rows/dimensions in QlikSense extension

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

erik_wetterberg
Honored Contributor

Re: More than 10 rows/dimensions in QlikSense extension

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

Erik Wetterberg
https://extendingqlik.upper88.com/
Community Browser