Parent -Child Hierarchy

[#1]

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

[#2]

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;

[#3]

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.

[kaushiknsolanki · Accepted solution]

Hi,

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

Regards,

Kaushik Solanki

[#5]

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

[kaushiknsolanki]

Hi

   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

[#7]

Hello Kaushik,

Thanks for your Answer