Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Hiearchy function creates duplicates

Hi Team,

            Need help I am having below date which is creating duplicates while creating hierarchy using hierarchy function. Please help me to resolve the issue

Nodetype: Country-> State->City

NodeID  ParentNodeID Nodename  Parentnodename nodetype

1             11                   one               Eleven               City

11            12                  Eleven          Twelve               City

11            13                  Eleven          Thirteen             State

12            14                  Twelve        Fourteen              State

13            15                  Thirteen      Fifteen                  Country

14            15                  Fourteen     Fifteen                 State     

Community Browser