topic Re: Pivot Table Issue in QlikView

Pivot Table Issue

Tue, 23 Jul 2013 15:25:39 GMT

I've run into an issue with a pivot table that I am at an absolute loss for. I have created a pivot table with 150 dimensions, and 10 expressions. Each dimension and expression is conditionally displayed, which allows the user to create a custom view into the data. The issue has come in when I add the 128th dimension. When I add this dimension, the expressions move from being columns to being rows. I've tested different dimensions to see if it was something about the field, but no matter what fields I use, the addition of the 128th dimension causes the pivot to move the position of the expressions. After the expression move to rows, there is no way for me to select those fields and try to move them back to the column position. I've looked through all of the documents settings and I can't see anything that would set the pivot table to work for only 127 dimensions. Is there a limit on the number of dimensions that will successfully display in a pivot? Has anyone run across this or have any idea what can be done to fix this? Any help would be fantastic. Thank you.

Re: Pivot Table Issue

Anonymous — Tue, 23 Jul 2013 18:18:25 GMT

Is it really necessary to allow so many dimensions at once? I recommend to use a restriction (probably by a macro), not allowing to select >127 dimensions. Or even better, no more than 20...

Re: Pivot Table Issue

Wed, 19 Feb 2014 22:09:48 GMT

Hi Travis - did you ever find a solution to this? I'm running into the same issue with a pivot and a large number of conditionally enabled dimensions/expressions. I've found that you can get the expressions to snap back in place but there is no rhyme or reason - you kind of just have to randomly drag and drop until it works. And of course this only temporarily fixes it as I've noticed they'll get thrown back out of place on Access Point.

Re: Pivot Table Issue

Wed, 19 Feb 2014 23:16:15 GMT

Hi Mark,

what version you are using ?

Roland

Re: Pivot Table Issue

Thu, 20 Feb 2014 12:38:45 GMT

11.2 SR5

Re: Pivot Table Issue

Wed, 10 Sep 2014 13:07:43 GMT

I have the same problem and use the 11:20 SR7, you've got feedback about the solution?

Tks

Re: Pivot Table Issue

Thu, 11 Sep 2014 11:56:10 GMT

today I got confirmation that the problem with the pivot table is a bug and has been surveyed with the ID 66058. I don't know when it will be fixed but I hope for the next SR.

Re: Pivot Table Issue

Thu, 11 Sep 2014 11:58:44 GMT

Hi Marco - we were essentially told that the R&D team will look at it but no ETA on a resolution.