topic Re: How to load Parent Child Record In QlikView in QlikView

How to load Parent Child Record In QlikView

Fri, 14 Aug 2015 10:30:15 GMT

Hello Dears

i want Show Parent Child Record In QlikView

Look Like This Sample.

Please Help Me.

Excel File Attach

rubenmarin — Fri, 14 Aug 2015 10:38:09 GMT

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

Withlevels:

Hierarchy(A, B,C)

LOAD A,

FROM

(ooxml, no labels, table is Sheet1);

ParentWithAllChilds:

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

LOAD A,

FROM

(ooxml, no labels, table is Sheet1);

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

Fri, 14 Aug 2015 10:47:01 GMT

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 — Fri, 14 Aug 2015 10:56:09 GMT

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

Fri, 14 Aug 2015 11:17:25 GMT

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 — Fri, 14 Aug 2015 11:25:50 GMT

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

Fri, 14 Aug 2015 11:30:05 GMT

Muchas Gracias