topic Pivot table performance issue in QlikView

Pivot table performance issue

Anonymous — Fri, 29 Sep 2017 16:52:39 GMT

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

Re: Pivot table performance issue

vvira1316 — Fri, 29 Sep 2017 17:21:03 GMT

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

Re: Pivot table performance issue

Anonymous — Fri, 29 Sep 2017 19:13:04 GMT

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

Re: Pivot table performance issue

vvira1316 — Fri, 29 Sep 2017 20:08:37 GMT

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.

Re: Pivot table performance issue

Anonymous — Thu, 05 Oct 2017 10:40:52 GMT

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