Hi everyone,
I've used account hierarchies in QlikView to analyze financial data (balance sheets, income statements, etc.).
So far, I had to transform data in excel to generate the data structure QlikView requires to recreate.
the account hierarchy (see: Hierarchy in QlikView ).
More specifically, I generated the hierarchy keys and parent keys with excel functions and vba programming
which is very time-consuming.
I am now trying to reduce the amount of time I have to spend to update hierarchies within the application to a minimum.
I would like to do the majority of the required transformation in the QlikView script.
I've managed to create a structure which is quite similar to the required one using the following code:
![Capture1.PNG](/legacyfs/online/156336_Capture1.PNG)
This creates such a table:
![Capture2.PNG](/legacyfs/online/156337_Capture2.PNG)
I now have to tell QlikView to use a combination of the column letter and row number from this table
as the hierarchy key (e.g. for account number 1110000: hierarchy key: D4, parent key: C3) so that
I can use the hierarchy in a list box.
Does anyone how to achieve this?
I will attach the source file and the sample application.
Please let me know if you have any further questions.
Thank you in advance.
Best regards,
Mats