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

[Anonymous]

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.

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.

[Vincenzo_Esposito]

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

[Anonymous]

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?