topic Re: Leveling in Pivot in QlikView

Leveling in Pivot

Tue, 27 May 2014 09:34:27 GMT

Hi,

I am developing a report based on a pivot table.

I have Level1, Level2, Level3, ... as dimensions.

what should I do to get all these levels fit within on column instead of normal drill down which creates a new column of each sub level.

Thanks for help.

Re: Leveling in Pivot

jvitantonio — Tue, 27 May 2014 09:43:51 GMT

Hi,

I'm not sure what you are trying to achieve, but you can either use a "Straight Table" instead of a pivot, or check the option "Always expanded" in the properties.

However, if what you want is to have all 3 levels in one column, then create a customized dimension like this:

=Level1&Level2&Level3

Best,

Re: Leveling in Pivot

PradeepReddy — Tue, 27 May 2014 09:54:35 GMT

Hi,

If I unserstand the requirement in rightway, you want to show case the pivot table data in expandable mode,always.

For this, rigt click on the dimension column select the "expand all " option.

Thanks,

Pradeep

Re: Leveling in Pivot

Tue, 27 May 2014 09:54:58 GMT

Thanks for your reply.

I am trying to group all dimensions in one column. I want the dimension to drill down within the same column.

If I have 9 levels, when set "always expanded" to true, I will get 9 different column.

Normal drill down:

L1 L2 L3 L4

L2 L3 L5

L1 L2 L3 L6

.....

What I want:

... all within the same column.
drilling down as a tree.

Re: Leveling in Pivot

Anonymous — Tue, 27 May 2014 09:59:46 GMT

You can use cyclic group option but limitation is that you can see only one level at time.

What you are saying is default behavior of pivot.if you want to see more that one dim it will create new column at each time.

Thanks & Regards

Kiran Kokade

Re: Leveling in Pivot

jvitantonio — Tue, 27 May 2014 10:02:25 GMT

Hi Elie,

you can't get this view in a pivot table.

You can only achieve a tree view in a list box. Please look for "Tree View in list boxes" in the help.

Thanks,