Draw table with data related in the same table

[#1]

Hi,

I´ve got the following data

File	Name	ID	TargetID	FlagTargetID
File_1	Name_A	xxx-111		0
File_1	Name_B	yyy-222	xxx-111	1
File_1	Name_C	zzz-333	yyy-222	1
File_2	Name_D	aaa-444		0
File_2	Name_E	bbb-555	aaa-444	1
File_2	Name_F	ccc-666	bbb-555	1
File_2	Name_G	ddd-777	ccc-666	1
....	....	....	....	....

and I would like to know how can I draw the following pivot table or similar.

File	Name
File_1
	Name_A
		Name_B
			Name_C
File_2
	Name_D
		Name_E
			Name_F
				Name_G
...	...	...	...	...

can any one help me please.

Thanks It advance

[petter]

This seems to work - a bit of a hack ... I think there must be a much simpler solution (included an attachment with the QVW too):

[mrossoit]

Hi,

why not tree view?

Check out the sample.

Regards

MR

[qlikviewwizard]

Nice explanation mrossoIT and petter-s

[#5]

All most got it, but still a littel bit lost,

The data Im trying to load several XML and them trying to mount like the table.

Thanks