Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amanjain57
Creator II
Creator II

Pivot Table takes longer time to show data ??

ex.jpg

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

11 Replies
jmvilaplanap
Specialist
Specialist

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
Creator II
Creator II
Author

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

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jmvilaplanap
Specialist
Specialist

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
Creator II
Creator II
Author

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
Specialist
Specialist

jmvilaplanap
Specialist
Specialist

There is a "super book" called Mastering Qlikview .

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

Take a look

CarmenReilly
Former Employee
Former Employee

Hi Aman!

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,

Carmen

amanjain57
Creator II
Creator II
Author

Thanks a lot !!

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