Reports show time very long

[Manlyhero]

Hi all,

We have some issue on our qlik repots. On our pipeline we have some views and those views will read by qlik than some joins made my qlik on qvd after that We are showing that aggreagated data on our dashboards.

But some reports take too much time to load.

We thinking two reason:

1) It's related to aggregated data size

2)Aggregation done by on UI end like dimensions which has complicated data calculation or additional aggregation.

Any suggestion on that one would be great

best Regards.

[Andrea_Bertazzo · Accepted solution]

Hi @Manlyhero 

Thanks for the message. It is not easy to suggest anything specific without the load script, but the quantity pf data to load and the complexity of formulas (especially aggregations) are among the main factors in the reload time.

Many suggestions to optimize the script can be found in community posts like this.

[SunilChauhan · Accepted solution]

Aggregated data coming from view should be ok as long query in view is optimised.

But aggregation at Ui slow down apps.

Try to move into script. Try to create star like schema. User autonumber to link text columns.

Remove unnecessary fields