Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

koushik_btech20
Contributor

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

Re: Hierarchy problem

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
Contributor

Re: Hierarchy problem

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

Not applicable

Re: Hierarchy problem

This hierarchy worked well for me.

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


Stylish Bathroom Vanities

er_mohit
Honored Contributor II

Re: Hierarchy problem

see the attached example of mine

hope it helps you

vikasmahajan
Honored Contributor III

Re: Hierarchy problem

Hello ,

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

Hope this help you.

Vikas

Community Browser