Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Luminary Alumni
Luminary Alumni

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!

View solution in original post

5 Replies
simondachstr
Luminary Alumni
Luminary Alumni

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
Author

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
Luminary Alumni
Luminary Alumni

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
Author

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

Thanks for your help.

simondachstr
Luminary Alumni
Luminary Alumni

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