topic Re: Tree view? in QlikView

Tree view?

Mon, 08 Jun 2015 13:38:30 GMT

Hi,

Can any one please help me to display the data on attached QVW in the tree view ??

Data:

Hierarchy:

Load * inline [

Child, ParentLevel 1, ParentLevel 2,ParentLevel 3,ParentLevel 4, HIghlevelParent,Level

Robin, , ,,,Robin,1

Kate, Harold,,,, Harold,2

Samules, Robert,Richard, ,,Richard,3

Samanta,Chris,Mike,Micheal,,Micheal,4

Chris,Mike,Micheal,,,Micheal,3

Mike,Micheal,,,,Micheal,2];

Expected tree view:

Robin-

Robin

Harold -

Kate

Richard-

Robert-

Samules

Micheal-

Mike-

Chris-

Samanta

Thanks

Re: Tree view?

buzzy996 — Mon, 08 Jun 2015 13:50:06 GMT

hopes this helps!

Re: Tree View In QlikView

Re: Tree view?

petter — Mon, 08 Jun 2015 13:58:49 GMT

You expected tree view seems a little bit inconsistent with your data. How can Robin - Robin be the same as Harold - Kate when the first i Level 1 and the second is Level 2?

Re: Tree view?

Mon, 08 Jun 2015 14:03:59 GMT

Hi Petter,

Sorry the result should be something like this

Expected tree view:

Robin-

Harold -

Kate

Richard-

Robert-

Samules

Micheal-

Mike-

Chris-

Samanta

Thanks

Re: Tree view?

buzzy996 — Mon, 08 Jun 2015 14:22:43 GMT

pfa,seems to be some data issue..try to modify data and see..

Re: Tree view?

petter — Mon, 08 Jun 2015 15:17:07 GMT

Here is a Tree View as you specified but I don't know if it will suit the rest of your requirements as you didn't specify much...

Re: Tree view?

Mon, 08 Jun 2015 17:59:12 GMT

Hi Petter,

Thanks a lot, this is what i am looking for . In the tree view list box can users select high level parent?

Re: Tree view?

petter — Mon, 08 Jun 2015 18:51:18 GMT

‌There must be some data associated with it to be able to select.

Re: Tree view?

petter — Mon, 08 Jun 2015 19:21:40 GMT

If you add these rows to your Hierarchy table all levels will be selectable:

	Harold ,,,,,Harold,1
	Micheal,,,,,Micheal,1
	Richard,,,,,Richard,1
	Robert,Richard,,,,Richard,2

Re: Tree view?

Mon, 15 Jun 2015 18:17:14 GMT

Hi,

Have a quick question.

On the Hierarchy list box, how to sort that list box so when i select a value its should appear on the top?

For example in the on the attached file, if i select Richard, it should appear on the top.

Re: Tree view?

juleshartley — Wed, 17 May 2017 13:26:22 GMT

This is a bug I believe...