topic Re: Financial Reporting & Hierarchy help in QlikView

Financial Reporting & Hierarchy help

DavidFoster1 — Sun, 19 Jul 2020 19:44:14 GMT

Something for the qlik gurus around.

I need to create typical P&L and Balance sheet reports. However the normal account code interval match wont work because the codes are non-sequential. The biggest challenge though is that the account hierarchy is a ragged hierarchy with irregular levels (e.g. one branch of revenue may have 3 levels another branch may have 4).

I am looking at using HierarchyBelongsTo functionality to identify the ancestors for each account. However I need some help on how to join that ancestor list to a financial report model.

For example:

A fictional ragged chart of accounts

Car A Sales > Car Sales > Revenue

Car B Sales > Car Sales > Revenue

Van Sales > Revenue

Car Costs > Cost of Sales

Van Costs > Cost of Sales

A P&L report has 3 rows

Revenue
Cost of Sales
Gross Margin

Revenue and Cost of Sales could both be mapped to ancestors of the same name, but Gross Margin would need to be mapped to both Revenue and Cost of Sales

Any advice on how I should model this is appreciated.

Thanks

David

Re: Financial Reporting & Hierarchy help

Saravanan_Desingh — Sun, 19 Jul 2020 22:57:25 GMT

Please share some sample data and expected output. That will be more easy to get response soon.

Re: Financial Reporting & Hierarchy help

Brett_Bleess — Wed, 29 Jul 2020 13:20:50 GMT

Best I can offer is the Design Blog area of Community, there are some posts on both areas you mentioned:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

Re: Financial Reporting & Hierarchy help

Onyi_Nwabia-Robbins — Wed, 24 Nov 2021 14:33:36 GMT

@DavidFoster1 did you ever find a solution for this?