# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

## Chart Of Account Sorting Logic

Hi Guys i was trying to creating logic for sorting chart of account,

Example :

Account Code :

10000

11000

12000

13000

COA:

10000..50000 -------> LV 1

11000-20000 ------> LV 2

11000..11999 -------> LV 3

12000..12999

13000..13999

14000..14999

i was using IntervalMatch function to find each parent of each account, but i cant define the level of the hierarchy.

what should i do to define the hierarchy correctly ?

expected result :
10000 = belong to 10000-50000
11000=  belong to 11000-20000 and 10000-50000

12000 = belong to 11000-20000 and 10000-50000

13000= belong to 11000-20000 and 10000-50000

Tags (3)
3 Replies
Valued Contributor

## Re: Chart Of Account Sorting Logic

Honored Contributor III

## Re: Chart Of Account Sorting Logic

Try this -

Interval:

Start, End

10000,50000

11000,20000

11000,11999

12000,12999

13000,13999

14000,14999 ];

Element:

AccountCode

10000

11000

12000

13000 ];

Inner Join(Element)

IntervalMatch(AccountCode)

Resident Interval;

Not applicable

## Re: Chart Of Account Sorting Logic

Hi Lucian and Digvijay

thanks for answering my question, both of you are helping me finding the answer.
but i decided to use Hierarchy function in qlikview to create the hierarchy

a function that look like this:

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

after you form the table with logic correctly, hierarchy function will be creating its level automatically.

Thanks and Regards,

Arviddree