Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Manlyhero
Contributor II
Contributor II

Reports show time very long

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.

Labels (1)
2 Solutions

Accepted Solutions
Andrea_Bertazzo
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂

View solution in original post

IamBack
Champion
Champion

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

 

 

 

 

View solution in original post

2 Replies
Andrea_Bertazzo
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂
IamBack
Champion
Champion

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