Pivot Table - Understanding the Calculation Logic while dimensions are hided / collapsed

chriys1337 — Sun, 27 Jan 2019 19:01:43 GMT

Hi,

I am having a general understanding question.

I have a Pivot Table with 2 dimensions, the second one is in my standard view collapsed. Will QV calculate the results (of the collapsed 2nd dimension)

a. already when entering the tab, altough just the first dimension is visible

b. for QV when it is hided, it is not calculated. ONLY when opening the Pivots second dimension the calculation for the second dimension will be done at this time?

I am very interested in this question, due to performance issues.

Re: Pivot Table - Understanding the Calculation Logic while dimensions are hided / collapsed

chriys1337 — Wed, 30 Jan 2019 08:30:04 GMT

I try it again, with a differently asked question: Does QlikView just calculate what is "visible", therefore when the Pivot collapsed, the breakdowns / the downstreamed calculations for hided dimensions are not done?

topic Pivot Table - Understanding the Calculation Logic while dimensions are hided / collapsed in QlikView

Pivot Table - Understanding the Calculation Logic while dimensions are hided / collapsed

Re: Pivot Table - Understanding the Calculation Logic while dimensions are hided / collapsed