QlikView Hierarchy Function - using an existing QlikView table as source

Anonymous — Wed, 15 Mar 2017 11:21:25 GMT

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

topic QlikView Hierarchy Function - using an existing QlikView table as source in QlikView