topic Re: Re: Pivot Table Error - Expressions Moving to Vertical Axis in QlikView

Pivot Table Error - Expressions Moving to Vertical Axis

Fri, 08 Nov 2013 19:58:06 GMT

Hi everyone,

I've got a Pivot Table with a number (100+) of conditionally enabled dimensions. For some reason my expressions keep moving from the horizontal axis and to the vertical axis. When I try to move the expressions back to the horizontal axis it then screws up the vertical axis.

For example, I want company code listed vertically. When I try to drag it down, the expressions also move.

Any tips?

See screen shots.

Re: Pivot Table Error - Expressions Moving to Vertical Axis

Sat, 09 Nov 2013 06:39:20 GMT

please attach your app

Re: Re: Pivot Table Error - Expressions Moving to Vertical Axis

Mon, 11 Nov 2013 12:54:58 GMT

The application is attached. I reduced what I could so only two of the conditionally enabled dimensions are active, but hopefully you see the issue I described.

Thanks.

Re: Re: Pivot Table Error - Expressions Moving to Vertical Axis

Tue, 12 Nov 2013 16:31:05 GMT

I contacted QlikTech and was told this behavior occurs when there are 127+ dimensions in a pivot table. R&D has the issue but there is no identified fix yet.