topic Parent -Child Hierarchy in QlikView

Parent -Child Hierarchy

Tue, 01 May 2012 15:38:43 GMT

Hi All,

I am having table like,

FunParaId	FunParaName	ParentId
1	fun1	NULL
2	fun2	NULL
3	fun3	NULL
4	fun4	NULL
5	fun5	NULL
6	fun6	NULL
7	fun7	NULL
8	fun8	NULL
9	fun9	1
10	fun10	1
11	fun11	10
12	fun12	10
13	fun13	1
14	fun14	1
15	fun15	1
16	fun16	2
17	fun17	2
18	fun18	2

In funparaname column i am having function names,Parameter names,sub parameter names,again sub parameter names.....like this i am having >1000 rows.I want to give the parent-childs relations based on ParentId = FunparaId.here ParentId is null it is a function name.

Ex- if parentid is 1 then Funparaname comes under fun1.if parentid is 10 then Funparaname comes under fun10.like this i want to give parent-childs relations.

How to give the logic for this in qlikview.any one knows about this one.pls help me.

regards,

baru

Parent -Child Hierarchy

Tue, 01 May 2012 15:48:53 GMT

Load the script below

Stephen

Data:LOAD * INLINE [
    F1, F2, F3
    1, Fun1
    2, Fun2
    3, Fun3, 1
    4, Fun4, 1
    5, Fun5, 5
    6, Fun6, 1
];

Child:

Load F1 as F1Child,

F2 as F2Child,

F3 as F1

resident Data;

Parent -Child Hierarchy

Tue, 01 May 2012 15:54:46 GMT

Hi Stephen,

Thanks for your reply,

here,i am fetching the data from database.And i am having >1000 rows,every day they updating the records in this table.

regards,

baru.

Re: Parent -Child Hierarchy

kaushiknsolanki — Tue, 01 May 2012 17:09:25 GMT

Hi,

Use the hierarchy function. Have a look at the sample application attached.

Regards,

Kaushik Solanki

Parent -Child Hierarchy

Tue, 01 May 2012 17:20:08 GMT

Hello Kaushik,

Thanks for the hierarchy solution, but the two tables are not linked. Won't this lead to potential problems in more

sophisticated table structures that need linking?

Stephen

Parent -Child Hierarchy

kaushiknsolanki — Tue, 01 May 2012 17:31:17 GMT

It depends on you which table to use. You can delete the first table and then link with your second table.

You can also use the hierarchyBelongsto() function. Have a look at the help for more info.

Regards,

Kaushik Solanki

Parent -Child Hierarchy

Thu, 03 May 2012 10:17:46 GMT

Hello Kaushik,

Thanks for your Answer