Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
koushik_btech20
Creator
Creator

Hierarchy problem

There is an account master table where I cannot make the proper hierarchy. What should be the parent and child node is very confusing to me..I am attaching the account master table. If anyone have the solution please share it.....

5 Replies
Not applicable

It may look somethign like this:

I just picked '>' this as a delimiter it can be anything you want.

Hierarchy (ACCNT_CODE,LOOKUP,ACCNT_NAME,'>')

The syntax is:

Hierarchy (NodeID, ParentID, NodeName, [ParentName], [PathSource], [PathName], [PathDelimiter], [Depth])(loadstatement | selectstatement)

koushik_btech20
Creator
Creator
Author

Please give me a the solution of the problem with .qvw file.........

Not applicable

This hierarchy worked well for me.

NodeID, ParentID, NodeName, [ParentName], [PathSource], [PathName], [PathDelimiter], [Depth])(loadstatement | selectstatement)


Stylish Bathroom Vanities

er_mohit
Master II
Master II

see the attached example of mine

hope it helps you

vikasmahajan

Hello ,

If you understand this is not confusing I created demo which you will understand pretty well.

Hope this help you.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.