topic Re: Creating a Tree view in a Pivot table in QlikView

Creating a Tree view in a Pivot table

reshmakala — Thu, 09 Oct 2014 17:04:33 GMT

Hello all,

I have a pivot table with 10 dimensions. I do not have a horizontal scroll bar and restrict the size of the pivot table. So if a user expands all the 10 levels the size of the pivot table increases a lot. My question is can I use tree view in my pivot table so that the columns do not expand horizontally but pop up as child nodes of the parent. Can anyone please help me?

Re: Creating a Tree view in a Pivot table

JonnyPoole — Thu, 09 Oct 2014 17:08:17 GMT

No problem.

You want 'indent mode' controlled on the style tab

Re: Creating a Tree view in a Pivot table

reshmakala — Thu, 09 Oct 2014 17:15:52 GMT

Thanks Jonathan!

But my requirement is to have a tree view. Even Indent mode expands the levels horizontally. I have attached some random pic of how I need it. Please help me if we can do so with pivot table.

Re: Creating a Tree view in a Pivot table

JonnyPoole — Thu, 09 Oct 2014 17:27:22 GMT

I tried to replicate your screenshot... how did i do ?

i enabled 'use only first dimension label' on the style tab and also out a blank for the first dimension label.

This has 6-7 dimensions, some of them with wider values than the example ...

Re: Creating a Tree view in a Pivot table

reshmakala — Thu, 09 Oct 2014 17:35:52 GMT

Could you please share the QVW? I guess this can solve my problem to some extent. Thanks

Re: Creating a Tree view in a Pivot table

reshmakala — Thu, 09 Oct 2014 17:55:14 GMT

Can you at least show me the changes in the properties with a screenshot? I do know enabling the first dimension label only...what was the other change that you have done to get such output?

Re: Re: Creating a Tree view in a Pivot table

JonnyPoole — Thu, 09 Oct 2014 18:01:13 GMT

Here is the QVW. Let me know if you have questions

Re: Creating a Tree view in a Pivot table

reshmakala — Thu, 09 Oct 2014 18:15:19 GMT

thanks!! I got it!!