topic Re: Chart Of Account Sorting Logic in QlikView

Chart Of Account Sorting Logic

Thu, 10 Mar 2016 11:35:33 GMT

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

Re: Chart Of Account Sorting Logic

luciancotea — Thu, 10 Mar 2016 13:29:37 GMT

Check this out: How to Create a Profit and Loss Statement in QlikView

Re: Chart Of Account Sorting Logic

Digvijay_Singh — Thu, 10 Mar 2016 14:18:10 GMT

Try this -

Interval:

Load * inline [

Start, End

10000,50000

11000,20000

11000,11999

12000,12999

13000,13999

14000,14999 ];

Element:

Load * inline [

AccountCode

10000

11000

12000

13000 ];

Inner Join(Element)

IntervalMatch(AccountCode)

Load Start, End

Resident Interval;

Re: Chart Of Account Sorting Logic

Tue, 15 Mar 2016 09:12:10 GMT

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