Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

amanjain57
Contributor

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
Valued Contributor

Re: Pivot Table takes longer time to show data ??

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
Contributor

Re: Pivot Table takes longer time to show data ??

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

MVP
MVP

Re: Pivot Table takes longer time to show data ??

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
Valued Contributor

Re: Pivot Table takes longer time to show data ??

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
Contributor

Re: Pivot Table takes longer time to show data ??

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
Valued Contributor

Re: Pivot Table takes longer time to show data ??

jmvilaplanap
Valued Contributor

Re: Pivot Table takes longer time to show data ??

There is a "super book" called Mastering Qlikview .

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

Take a look

cri
Contributor

Re: Pivot Table takes longer time to show data ??

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
Contributor

Re: Pivot Table takes longer time to show data ??

Thanks a lot !!

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

Community Browser