Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table Error - Expressions Moving to Vertical Axis

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.

11-8-2013 2-53-55 PM.png

11-8-2013 2-55-02 PM.png

3 Replies
Not applicable
Author

please attach your app

Not applicable
Author

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.

Not applicable
Author

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.