topic Pivot table performance improvement in QlikView

Pivot table performance improvement

nakuldev — Sat, 16 Nov 2024 02:09:51 GMT

Hi All,

PFA the QVW which contains two pivot tables which are creating performance issues when ever I select multiple months/weeks in the filters. Could someone help me simplifying this.

Thank you in advance.

Regards

Nakul

Re: Pivot table performance improvement

MarkWillems — Tue, 22 Oct 2019 12:55:53 GMT

All of the work in the calculated dimension and then the large expression should be done in the script, using fields as dimensions to label the data correctly. Doing this work in the pivot table itself is creating the huge overhead.

Re: Pivot table performance improvement

marcus_sommer — Tue, 22 Oct 2019 12:57:41 GMT

You need to develop another logic for your datamodel to work just with native dimensions and simple expressions like: sum/count(value). Creating synthetic dimensions with valuelist() and using expressions with multiple nested if-loops respectively pick(match()) is very poorly from a performance point of view.

- Marcus