topic Re: hierarcy in QlikView

hierarcy

Mon, 12 Sep 2011 18:42:21 GMT

Hi,

I am trying to build the hierarchy using the recursive way since the data is not organzied. I tried concatenating and use it is working. But i am not sure how to use the hierarchy and hierarchy belongs on thge below data.

Parent	Child	Name
1	11	a
2	12	b
3	13	c
4	14	d
5	15	e
6	16	f
7	17	g
8	18	h
9	19	i
10	20	j

Another seperate parenchild table,

Parent	Name1	Name
p	aa	a
c	bb	b
p	cc	c
c	dd	d
p	ee	e
c	ff	f
p	gg	g
c	hh	h
p	ii	i
c	jj	j

Re: hierarcy

Mon, 12 Sep 2011 19:18:38 GMT

Hi,

i hope this help you.

C u,

Stefano.

hierarcy

Tue, 13 Sep 2011 13:23:25 GMT

Thanks for your response.

Can u please provide me a sample qvw for the given data.

Re: hierarcy

Tue, 13 Sep 2011 15:05:24 GMT

Hi,

but thoose table not seem to be Adjacent Nodes table.

Is it your real situation or your example?

hierarchy and hierarchybelongsto want Adjacent Nodes Table in input.

Each node in the 1st table has different parent and in the 2nd the root is not present.

C u,

Stefano.

hierarcy

SunilChauhan — Tue, 13 Sep 2011 15:12:29 GMT

rename parent in sect table

left join first with second on basis of Name

then apply hierarchy

Paren&'/'&Child&'/'&Name ... as hierarchy

take hierachy in list box and in general check on tree view and provide seperator