search

iviasensio / PLSmartPivot

PL Smart Pivot Report for Qlik Sense
MIT License
19 stars 19 forks source link

Limited Column Number #27

Open undsoul opened 4 years ago

undsoul commented 4 years ago

Hi Ivan ,

Is there a way to modify "10 column rule" in jscript ?

One of my customer is willing to use with 15 column .

Thanx in Advanced, Br,

iviasensio commented 4 years ago

Hi undsoul

Sure. Open PLSmartPivot.js Modify the parameters (at the line 13): qInitialDataFetch : [{ qWidth : 10, replace for 16 (15 measures + 1 dimension) qHeight : 1000 replace for 625 (10.000 / 16 = 625) }] If you need up to 15 measures modify the parameters (at line 27): measures : { uses : "measures", min : 1, max : 9, replace for 15 }, Note that qlik extensions work with an interface with the engine that only accepts a matrix of data with a maximum of 10k cells. The code of the extension can request for new data if you have more than 10k cells, but only 10 loops is admited. So real maximum of data accepted by an extension is 100k.

Regards