Qlik Community

Qlik Sense Integration, Extensions, & APIs

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

billgates
Contributor

[Qlik Sense Desktop 3.2 SR3] The hypercube results are too large, when I trying to show table with many records

Hello, experts!


I'm working with extension SmartExport


SmartExport/SmartExport.js at master · iviasensio/SmartExport · GitHub

This extension works fine, when table has not so many records.

But if table has many records, I receiving error. The hypercube results are too large.

pic1.png

May I do something to increase max hypercube size?

Or any other suggestion? What should i do to solve this error?

May be i should override hypercube parameters by something like this?

qHyperCubeDef : {

qDimensions : [],

qMeasures : [],

qInitialDataFetch : [{

qWidth : 10,

qHeight : 50

}]

},

Thanks.

Tags (2)
2 Replies
Employee
Employee

Re: [Qlik Sense Desktop 3.2 SR3] The hypercube results are too large, when I trying to show table with many records

You can change qWidth (number of returning columns) and qHeight (number of returning rows).

billgates
Contributor

Re: [Qlik Sense Desktop 3.2 SR3] The hypercube results are too large, when I trying to show table with many records

Hi, Vincenzo Esposito!

Thanks for your reply.

I modified code to next:

          return {
               initialProperties: {
                    version: 1.0,
                    showTitles: false,

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

               }, paint: function ( $element ) {
               toggleId.call();
               }
          };

And looks like it is not working. I have same error.

May be I did something wrong?

Community Browser