Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
This creates such a table:
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