Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Need help with hierarchy

jagan‌  stalwar1

Hi All

I need some help with hierarchy

I have data like below

FromTableFromFieldtotabletofieldqualifier
Cf1Df2FinalTarget
Cf3Df4FinalTarget
Bf5Cf1qualifier
Af6Cf3qualifier
Pf7Af6beginning
Pf8Bf5

I have to map columns across qualifiers

here based on the qualifier FinalTarget is the Target table

so D.f2--C.f1--B.f5--P.f8 so column "f2 in table D" is coming originally from "f8 column in table P"

sameway D.f4--C.f3--A.f6--P.f7 so column "f4 in table D" is coming originally from "f7 column in table P"

Can we achieve something like this

Tags (1)
1 Reply
dewilded
New Contributor II

Re: Need help with hierarchy

Hi,

There is a very good technical brief on this Hierarchies

In the end of the pdf there is an example with a great explanation how to use this.

For your case you should use tofield as NodeID and fromfield as ParentID in this example.

Kind regards,

David