How to load Parent Child Record In QlikView

[#1]

Hello Dears

i want Show Parent Child Record In QlikView

Look Like This Sample.

Please Help Me.

Excel File Attach

[rubenmarin]

Hi leila, Hierarchy() and HierarchyBelongsTo() are used to create parent-child relations, as example:

Withlevels:

Hierarchy(A, B,C)

LOAD A,

     B,

     C

FROM

(ooxml, no labels, table is Sheet1);

ParentWithAllChilds:

HierarchyBelongsTo (A, B, C, 'ParentId', 'ParentName')

LOAD A,

     B,

     C

FROM

(ooxml, no labels, table is Sheet1);

Create table boxes with fields from different trables to check the result.

[#3]

Hi Ruben ,

Thank you for your answer

But I Can not Understand When Set In Load Script,

You can write a practical example (Excel File Attach).

i want Show in Chart Look Like Pivot Chart

[rubenmarin · Accepted solution]

Hope this helps.

First sheet table boxes to check how data is loaded.

2nd. sheet an example of pivot table.

when to set depends on script it can be anywhere, when you want or need to load the structure

[#5]

this is perfect Thanks,

Muchas Gracias

Can also be applied on the chart without Hierarchy Or HierarchyBelongsTo in load Script.?

i want Load Clear in load Script And Pivot Show Hierarchy

[rubenmarin]

De nada.

I don't know a way to do in chart, maybe there is a way using calculated dimensions but if exists it would be more complex than creating in script

[#7]

Muchas Gracias