6 Replies Latest reply: May 3, 2012 6:17 AM by Baru - RSS

Parent -Child Hierarchy

Baru -

Hi All,

 

I am having table like,

FunParaIdFunParaNameParentId
1fun1NULL
2fun2NULL
3fun3NULL
4fun4NULL
5fun5NULL
6fun6NULL
7fun7NULL
8fun8NULL
9fun91
10fun101
11fun1110
12fun1210
13fun131
14fun141
15fun151
16fun162
17fun172
18fun182

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