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: 
Anonymous
Not applicable

Pivot table performance issue

Hi All,


I have dataset of 10million..and this data has been consumed by Pivot table and date field is being pivoted...which is taking lot of time to display..literally hanging the application and refreshing back to landing page. Please let me know if you have any solutions or any other alternative approaches to resolve performance issue.


Regards,

Chetan Kumar Gopinath

4 Replies
vvira1316
Specialist II
Specialist II

Hi Chetan,

Would you be able to share a sample of your data and app? It will help to help you, without that not I'm not sure how someone will be able to provide any suggestion.

BR,

VIjay

Anonymous
Not applicable
Author

Hi Vijay,


As I mentioned we have approx 10 milliion fact data, as of now i have exttracted 5weeks dataset for your reference and attached the same along with application screenshot.

Regards,

Chetan

vvira1316
Specialist II
Specialist II

Hi Chetan,

Thanks for sharing it. As it is limited set and also not sure what your data model actually looks like. It will be difficult to replicate scenario and know what may be impacting. I've tried recreating pivot table.

Please advise what your scenario looks like, if it is different then what I've done so far. Expression, data model, etc.

Anonymous
Not applicable
Author

Hi Vijay,

I was on vacation, sorry for the delayed response.

I reviewed the app you have prepared with data I provided and its right. Now since same data in my data model takes approx. 5-6 to load entire data, however there is a chances of refreshing the entire application. I am repeating same, my data model has huge number of records, like ~10 million. No complicated expression in pivot too. Lets say now you increase same data by 5 times. I am very sure performance will take a hit.

I know you may ask to handle in data model to load faster, expect the pivot chart rest other objects loads faster. So I need your input for alternative solution or techniques to load pivot faster. Any thoughts?

Regards,

Chetan