Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

justin_morley
Contributor

Extension - initial data fetch of All data

Hi,

I'm just wondering if there is any way to pass all selected data into an extension at once?

initialProperties : {

     qHyperCubeDef : {

          qDimensions : [],

          qMeasures : [],

          qInitialDataFetch : [{

               qWidth : 2,

               qHeight : 50

          }]

     }

}

The initial properties can be set up with a fixed qHeight, is there any shorthand to say All data?

Unfortunately with the visualization I'm producing I can't really page the data in.

I've seen the manual page here:

http://betahelp.qlik.com/0.95/en-US/online/index.html#../Subsystems/QlikView_Workbench_Guide/Content...http://betahelp.qlik.com/0.95/en-US/online/index.html#../Subsystems/QlikView_Workbench_Guide/Content...

about retrieving additional data, but I always know I need the whole selected data set.

Thanks in advance,

Justin

1 Solution

Accepted Solutions
erik_wetterberg
Valued Contributor III

Re: Extension - initial data fetch of All data

Yes, there is a limit, not on rows, but on number of cells. It is currently set at 10.000 cells. The reason for this is to avoid unresponsive objects that seem to not work.

If you need all data and it might be more than 10.000 cells you need to retrieve it in chunks(using the getData method) and preferably show something to the user as soon as possible.

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

Re: Extension - initial data fetch of All data

Hi Justin - let's see if Alexander Karlsson or Brian Munz might be able to help you.

Mike

justin_morley
Contributor

Re: Extension - initial data fetch of All data

Some additional info: When I set the qHeight to an arbitrarily large amount, the visualisation fails to render. There seems to be a threshold over which it no longer wants to work. Is there a hard product limitation?

I'm trying to build a pretty sophisticated visualisation on top of a large quantity of data - an embedded scrollable div and custom built trellising. It's actually looking pretty sweet, it'd be a shame if a data limit rendered it an impossibility for all cases.

erik_wetterberg
Valued Contributor III

Re: Extension - initial data fetch of All data

Yes, there is a limit, not on rows, but on number of cells. It is currently set at 10.000 cells. The reason for this is to avoid unresponsive objects that seem to not work.

If you need all data and it might be more than 10.000 cells you need to retrieve it in chunks(using the getData method) and preferably show something to the user as soon as possible.

Erik Wetterberg
https://extendingqlik.upper88.com/
ogster1974
Honored Contributor II

Re: Extension - initial data fetch of All data

http://blog.axc.net/?p=1617

It appears the max is 1000 at the moment been reading about it in getting started with extensions in the link above

Also explains why the built in scatter chart isn't displaying data unless heavily filtered at the moment.