topic Balance Sheet Grouping in QlikView

Balance Sheet Grouping

neetu_singh — Thu, 09 Sep 2010 05:42:36 GMT

Dear All,

I have a query, i want to create a group for Balance Sheet in Finance Module but that grouping should be dynamic. As, i m having ledger code and ledger description. Example:

LdgrCode LdgrName

10000 A

10001 B

10002 C

11000 D

11001 E

It means "B and C" are sub group of A and "E" is the sub group of D. then, how we can create that grouping dynamically.

If anyone know the solution. please reply me ASAP. its urgent

Thanks in advance

Regards

Neetu Singh

Balance Sheet Grouping

tresB — Thu, 09 Sep 2010 06:11:40 GMT

Hi mam'm,

Please have look at attached application. Hope the logic would help you.

Thanks & regards,

tresesco

Balance Sheet Grouping

neetu_singh — Thu, 09 Sep 2010 08:03:20 GMT

Hi Tresesco,

Thanks for your reply but my problem is something different. I attached a test application which help you to understand the scenario.

So, Please have a look on that. i am very thankful to you if you are able to sort out.

Thanks

Neetu Singh

Balance Sheet Grouping

tresB — Thu, 09 Sep 2010 08:57:45 GMT

Hi,

As far as i have understood, you need another recursion (Group->SubGroup->Desc). Please find the modified application. The proper use of string functions would give you the desired result i believe.

Thanks..

Balance Sheet Grouping

Thu, 09 Sep 2010 09:08:57 GMT

Hi Neetu,

I think to achieve this you should have the parent code in the transactions.

LOAD * INLINE [
LedgrCode, Name, ParentCode
110000, Land,
110250, Owned Land, 110000
110260, Owned Land, 110000
110270, Additional OL, 110250
110280, Deletion OL, 110250
];

To make a result set as requested. After that you can use hierarchy function to create the same hierarchy as you need for this balance sheet.

Hope it iwll help you.

Regards,

Raj Kishor

Balance Sheet Grouping

neetu_singh — Fri, 10 Sep 2010 05:39:18 GMT

Hi Raj,

Thanks.

Re: Balance Sheet Grouping

Wed, 17 Apr 2013 16:38:36 GMT

I am trying to create the following look from my table. These two columns are available and properly populated as parent and child. How can I get this look?