Sankey Chart with more than 10K data

[Anonymous]

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.

[vamsee]

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

[Anonymous]

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?