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