topic Pivot Table fixed dimension in QlikView

Pivot Table fixed dimension

Anonymous — Tue, 01 Mar 2016 14:19:38 GMT

Hi all,

how can i fix a certain Dimension in Pivot Table?

Example:

Hierarchy_Lvl 1	Hierarchy_Lvl 2	Date	Fact
abc	abc_2	12-24-15	145
def	def_2	12-24-15	1864

The Hierachy can be expanded. But the Date-Dimension Column should always be visible. Regardles how "deep" the nodes are expanded.

-phil

Re: Pivot Table fixed dimension

Gysbert_Wassenaar — Tue, 01 Mar 2016 15:29:56 GMT

No, that's not possible. Either all dimensions are always fully expanded or all dimensions can be collapsed and expanded.

Re: Pivot Table fixed dimension

Tue, 01 Mar 2016 15:50:48 GMT

You can't achieve that in Pivot object. only work around I would advise is, If you will have always only one date under the combination of Hierarchy lvl 1 & 2 then you can add the date column as an expression.

But this doesn't work if you have more than one date under each level1 & level 2 combination