topic Re: Pivot Table Nightmare - Horizontal Columns Not Showing in QlikView

Pivot Table Nightmare - Horizontal Columns Not Showing

wonkymeister — Fri, 09 Oct 2015 14:11:22 GMT

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.

Re: Pivot Table Nightmare - Horizontal Columns Not Showing

Peter_Cammaert — Fri, 09 Oct 2015 15:46:14 GMT

Sounds almost like a bug?

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

Best,

Peter

Re: Pivot Table Nightmare - Horizontal Columns Not Showing

wonkymeister — Mon, 12 Oct 2015 09:07:29 GMT

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.