Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Only 1000 lines returned for display

Hello,

I am currently working on a dashboard with Qlik Sense Desktop (version 3 - but the same issue also was there in version 2) using a Sankey extension from Qlik Branch (Qlik Branch) . The extension works very well (with 4 dimensions). But I realized that Qlik only provides 1000 lines to the extension - which can be seen in the following screenshot:

Capture.PNG

Is there some limitation in Qlik Desktop on how many lines can be displayed in a chart? If so, is there any way to work around that?

Thanks and regads!

1 Solution

Accepted Solutions
simondachstr
Valued Contributor III

Re: Only 1000 lines returned for display

To quote a post by swr‌  taken from https://community.qlik.com/thread/186836

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

  1. initialProperties: { 
  2.   qHyperCubeDef: { 
  3.   qDimensions: [], 
  4.   qMeasures: [], 
  5.   qInitialDataFetch: [ 
  6.        { 
  7.        qWidth: 4
  8.        qHeight: 2500
  9.        } 
  10.   ] 
  11.   } 

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!

5 Replies
simondachstr
Valued Contributor III

Re: Only 1000 lines returned for display

To quote a post by swr‌  taken from https://community.qlik.com/thread/186836

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

  1. initialProperties: { 
  2.   qHyperCubeDef: { 
  3.   qDimensions: [], 
  4.   qMeasures: [], 
  5.   qInitialDataFetch: [ 
  6.        { 
  7.        qWidth: 4
  8.        qHeight: 2500
  9.        } 
  10.   ] 
  11.   } 

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!

Not applicable

Re: Only 1000 lines returned for display

Thanks for this hint!

Is this limitiation on 10.000 cells comming from the (free) Desktop version of Qlik Sense? Or is it also in "paid" version?

Thanks again!

simondachstr
Valued Contributor III

Re: Only 1000 lines returned for display

The limitation is per qHyperCube datapage and exists in all versions of Qlik Sense. But it also makes sense - displaying more than 10.000 data points in a visualizations

a) will not make much sense to a user (think of overcrowded visualizations)

b) will impact performance as everything is rendered in the browser.

That being said, there are ways to bring in more than 10.000 data cells by loading multiple data pages. This is advanced extension development, however in this case you should challenge yourself whether you are forcing Qlik Sense to do something it is not designed to be doing (e.g. using it as a data exportation tool).

Not applicable

Re: Only 1000 lines returned for display

Does this limitation also exist in QlikView? Is this so to say a common limitation or QlikSense-specific?

Thanks for your help.

simondachstr
Valued Contributor III

Re: Only 1000 lines returned for display

This is a Qlik Sense limitation specific to its extensions (which are using qHyperCubes).