Skip to main content
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
Showing results for 
Search instead for 
Did you mean: 

Financial Reporting & Hierarchy help

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

  1. Revenue
  2. Cost of Sales
  3. 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.



3 Replies

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

Former Employee
Former Employee

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


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Contributor III
Contributor III

@DavidFoster1 did you ever find a solution for this?