Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Draw table with data related in the same table

Hi,

I´ve got the following data

FileNameIDTargetIDFlagTargetID
File_1Name_Axxx-1110
File_1Name_Byyy-222xxx-1111
File_1Name_Czzz-333yyy-2221
File_2Name_Daaa-4440
File_2Name_Ebbb-555aaa-4441
File_2Name_Fccc-666bbb-5551
File_2Name_Gddd-777ccc-6661
....................

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

FileName
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

4 Replies
MVP
MVP

Re: Draw table with data related in the same table

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):

2015-05-08 #3.PNG

2015-05-08 #2.PNG

mrossoit
Contributor II

Re: Draw table with data related in the same table

Hi,

why not tree view?

Check out the sample.

Regards

MR

Arjunarao
Honored Contributor II

Re: Draw table with data related in the same table

Nice explanation mrossoIT and petter-s

Not applicable

Re: Draw table with data related in the same table

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

Community Browser