Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

masch112
Contributor

QlikView Hierarchy Function - using an existing QlikView table as source

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

This creates such a table:

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

Community Browser