Pivot Table takes longer time to show data ??

[amanjain57]

Hi if you see the attached, the pivot table takes longer to load the data.

What is the reason behind this and the solution??

I have almost 2 million rows of data in my application

[jmvilaplanap]

Hi,

I supose that there is more info and formulas that in the graphs, and this is the reason because the pivot table is slower than the other objects.

I see almost 14 columns, is much more than the other graphs (with only one measure each)

Regards

[amanjain57]

Hi Jose, thanks for your reply . What is the solution then?

[jonathandienst]

Well one can't really diagnose a problem based only a picture, but presumably the aggregation level of the pivot is low so it is generating very many rows, or it contains complex (and possibly poorly optimized) expressions.Of you post more details and/or a small sample containing the table in question, you may get more detailed advice.

[jmvilaplanap]

First of all, are you sure you need all this data?

If yes, can you optimize the expressions? or maybe you can create a table in the scrip with more aggregated data.

Or try to divide the table in parts or put it in another sheet.

[amanjain57]

Hi Jose, yes I need all this data.

Can you guide me to a module on Qlik that speaks about optimizing expressions or creating a table in script with more aggregrated data?

[jmvilaplanap]

improving QlikView performance

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/application-performance-

optimization.htm‌

Try with this two pages, or try to re-model your app to make the aggregations before

[jmvilaplanap]

There is a "super book" called Mastering Qlikview .

You can learn a lot of ways to improve the dashboard performance.

Take a look

[CarmenReilly]

Hi Aman!

These resources may be helpful to you:

• Performance and Optimization Best Practices in QlikView & Qlik Sense: https://community.qlik.com/docs/DOC-17608‌
• The Qlik® Associative Engine memory management and CPU usage: https://www.qlik.com/us/resource-library/qlik-associative-engine-memory-management-cpu‌
• Qlik Sense® Performance Benchmark: https://www.qlik.com/us/resource-library/qlik-sense-performance-benchmark‌
• Qlik Sense Enterprise - Architecture and Scalability Technical White Paper: https://www.qlik.com/us/resource-library/qlik-sense-enterprise-architecture-and-scalability‌

You can also take a look at:

• Best Practices for Data Modelling: https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/DataModeling/best-practices-da...‌

I'm not sure how you're set up right now, but you could also look at loading from QVD files: https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Scripting/work-with-QVD-files....

All The Best,

Carmen

[amanjain57]

Thanks a lot !!

I am not really good with data modelling but I will try to understand to make this work.