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
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)
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.
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.
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?
Try with this two pages, or try to re-model your app to make the aggregations before
These resources may be helpful to you:
You can also take a look at:
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,