Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to load Parent Child Record In QlikView

Hello Dears

i want Show Parent Child Record In QlikView

Look Like This Sample.

Please Help Me.

Excel File Attach

3000.png

1 Solution

Accepted Solutions
Highlighted

Re: How to load Parent Child Record In QlikView

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

View solution in original post

6 Replies
Highlighted

Re: How to load Parent Child Record In QlikView

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.

Highlighted
Not applicable

Re: How to load Parent Child Record In QlikView

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

Highlighted

Re: How to load Parent Child Record In QlikView

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

View solution in original post

Highlighted
Not applicable

Re: How to load Parent Child Record In QlikView

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

Highlighted

Re: How to load Parent Child Record In QlikView

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

Highlighted
Not applicable

Re: How to load Parent Child Record In QlikView

Muchas Gracias