Optimising a dashboard .... +50m rows

[#1]

HI,

we are currently seeing some performance issues with our dashboard. One sheet in particular has a table chart with a large cyclic dimension (about 15 options).  As the chart is 'drawn' when the sheet loads would it be faster to show / hide the chart on a button click? So in effect 15 hidden charts and these are only drawn when selected? Or is this counter active?

One other question I have is around our data structure.  At the moment we have a link table with many source table adjoining it (star effect).  are there any alternatives to this set up which could  optimise the speed?

THanks for any help

tjm

[kaushiknsolanki]

Hi,

You can use the "Conditional" option under General Tab, to make chart render only if the certain condition is met.

This way when user opens the sheet and the chart condition is not met it will be loaded faster then without condition.

Also you should look at the below link.

Performance and Optimization Best Practices in QlikView & Qlik Sense

Regards,

Kaushik Solanki

[thomaslg_wq]

Hi Tim,

Could you please provide some more intel for us to help you,

As a screenshot of your data model, maybe your script in a txt file and also a screenshot of the particular sheet and expressions in charts.

Is the granularity of your data optimized ? I mean,maybe you could aggregate value by period or categories, etc.

Maybe a linked table is not mandatory, except if you want some cross-source comparisons, etc.

BR,

Thomas Le Gall

[tajmohamed30]

Large amount of data (120 million rows) ... anyone got experience?