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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
wonkymeister
Creator III
Creator III

Pivot Table Nightmare - Horizontal Columns Not Showing

Hi,

I've built a pivot table object with conditional columns. As a typical pivot, there's a horizontal column and a vertical column. The user can select fields from list boxes to display in either the horizontal or vertical columns.

The list boxes are created via inline loads, and are called DataToShowH and DataToShowV. Then in the conditions in the pivot chart, each dimension has the condition: DataToShowH = 'FieldName' and DataToShowV = 'FieldName'.

The problem i'm experiencing is the horizontal column often disappears, or doesn't refresh when a new horizontal column is selected.

Vertical is fine. But horizontal keeps disappearing (all very random).

anybody any ideas? i've seen lots of posts about pivots being awkward to format.

this issue is occurring in both Chrome and IE, but works fine in the Plugin.

11.2, SR12.

2 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Sounds almost like a bug?

Care to post an example document with a pivot table that exhibits the same behavior?

Best,

Peter

wonkymeister
Creator III
Creator III
Author

Oooooopsss...........

looks like its a bug that's been fixed in the SR11 release

62258 Pivot table: Cyclic work and Enable Conditional mot working in some scenarios

i'd better get patching.