Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Highlighted
nivedita2590
New Contributor II

Sankey Chart with more than 10K data

Hi All,

I am using Sankey chart in my application. I need to get all the data (more than 10K cells) before rendering  the chart. Please guide me as to how I can do this without  the application. getting slowed down / hanged. I use 1 measure and 6 dimensions in it. Total number of rows are about 46654.

2 Replies
vamsee
Valued Contributor

Re: Sankey Chart with more than 10K data

Hello,

Can you share an sample qvw with the chart.

A chart performance would be based on the expressions used.

Try to avoid if statements with aggregations.

http://www.johndaniel.com/index.php/4-ways-optimize-qlikview-application-performance/

For Sankey charts, here is an excellent document. Visualizing Paths and Flow with Sankey Diagrams

nivedita2590
New Contributor II

Re: Sankey Chart with more than 10K data

Hi,

  I have attached the sample qvf for Sankey chart. I tried getting all data (for 6 dimensions and 1 measure)and then rendering the chart but the application slowed down terribly. Aim is to get all data and generate nodes and links in such way that application does not slow down or hang and also provide correct total of frequency on node tooltip which normally gets only initial 10K cells and shows the total accordingly. On click of node when its get some more area ,it fetches more data and the total increases. Thus the total is never made using complete data.  Can you have a look at the chart and suggest some solution?

Community Browser