topic Re: Optimising a dashboard .... +50m rows in QlikView

Optimising a dashboard .... +50m rows

Thu, 15 Jun 2017 10:21:09 GMT

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

Re: Optimising a dashboard .... +50m rows

kaushiknsolanki — Thu, 15 Jun 2017 10:29:07 GMT

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

Re: Optimising a dashboard .... +50m rows

thomaslg_wq — Thu, 15 Jun 2017 12:04:12 GMT

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

Re: Optimising a dashboard .... +50m rows

tajmohamed30 — Thu, 15 Jun 2017 14:53:36 GMT

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