topic Re: Create TreeView in Pivot Table in QlikView

Create TreeView in Pivot Table

Anonymous — Tue, 22 Sep 2015 03:05:58 GMT

Hi,

I have a question about changing the design of pivot table.

I have a pivot table like this:

I want to change the design to a treeview design like this one:

So when i click the expand (+ symbol) the chart will expand under the person not beside the person dimension.

Is it possible to make it ?

Really need your help, Thanks

Re: Create TreeView in Pivot Table

avinashelite — Tue, 22 Sep 2015 05:10:45 GMT

As per my knowledge expanding under the header is not possible

Re: Create TreeView in Pivot Table

jonathandienst — Tue, 22 Sep 2015 05:26:15 GMT

On Chart Properties | Style, check the Indent Mode checkbox.

Re: Create TreeView in Pivot Table

Anonymous — Tue, 22 Sep 2015 09:01:20 GMT

Hi Jonathan,

thanks for your suggestion, it works perfectly, but i have a problem when i move the layout.

I have 3 dimension (Person, Area, Brand) and 2 expression (Qty1, Qty2) When i move the Qty beside Area, the Area column not show. Is it possible to make the area column shown again ?

I also attach my qvw file

The result i Expect is like this:

Brand A Brand B Brand C

Person A

Area1

Qty1 10 .... ....

Qty2 10 .... ....

Area2

Area3

.......

Thanks